====== 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