====== pears.NetOwnerJobRateList ====== Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. ===== Original SQL ===== 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