pears.AddressValidation

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

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
  • database/functions/pears_addressvalidation.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1