pears.AddressValidation [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== pears.AddressValidation ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code 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
</code>