pears.FormatCompanyAddress
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"."FormatCompanyAddress" IS {CREATE FUNCTION FormatCompanyAddress /* Application Maintained Function / Procedure - DO NOT EDIT*/ (IN ReqCompanyID CHAR(20),IN Capitalise SMALLINT,IN STYLE CHAR(1)) RETURNS long VARCHAR BEGIN DECLARE FormattedAddress CHAR(300); SET FormattedAddress=FormatCompanyAddress1_0(ReqCompanyID,Capitalise,STYLE); RETURN FormattedAddress END }