====== pears.FormatPersonAddress ====== Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. ===== Original SQL ===== COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."FormatPersonAddress" IS {create function 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 }