====== pears.AddressValidation ====== Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. ===== Original SQL ===== create function "pears"."AddressValidation"( in @RecordType char(1),in @RecordID char(20),in @Addr1 char(100),in @Addr2 char(100),in @Addr3 char(100),in @Town char(100),in @County char(100),in @Country char(100),in @Postcode char(100) ) returns long varchar -- Non-Maintained Function -- -- @RecordType P - Person, C - Company, V - Vacancy -- Success is indicated by the return of a null string, any other response indicates a problem. -- If the response starts with a caret (ie ^) the message should be treated as a warning rather than an error -- begin declare @RV long varchar; return(@RV) end