====== pears.FormatPersonAddress ====== Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. ===== Original SQL ===== create function "pears"."FormatPersonAddress"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "ReqPersonID" char(20),in "Capitalise" smallint,in "Style" char(1) ) returns long varchar begin declare "FormattedAddress" char(300); set "FormattedAddress" = "FormatPersonAddress1_0"("ReqPersonID","Capitalise","Style"); return "FormattedAddress" end