create function "pears"."NetOwnerJobRateList"()
returns long varchar
begin
declare "rv" long varchar;
select "list"("string"("TempPayBandID",']~[',"TempPayBand"."Description"+' - '+"TempPayBand"."Unit"),']~[' order by "Description" asc) into "rv" from "TempPayBand";
return "rv"
end