pears.ValidateEmailAddressStd

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

Original SQL

CREATE FUNCTION "pears"."ValidateEmailAddressStd"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN @email VARCHAR(200) ) 
RETURNS long VARCHAR
BEGIN
  DECLARE "RV" long VARCHAR;
  SET "rv" = IF EXISTS(SELECT 1
      FROM "sa_split_list"(@email,';')
      WHERE "trim"("row_value") NOT REGEXP "string"('^[a-zA-Z0-9.!#$%&',"char"(39),'â€™*+/=?^_`{|}~-]+@[a-zA-Z0-9-]+(?:\\.[a-zA-Z0-9-]+)*$')) THEN
      'Invalid Email Address' ELSE '' endif;
  RETURN("RV")
END