devxlogo

Handy Function to Test for Email Validity

Handy Function to Test for Email Validity

Use this nifty function to check the validity of an email address.

CREATE FUNCTION [dbo].[fnCheckEmail](@Email VARCHAR(255))   RETURNS BIT  AS  BEGIN       DECLARE @ValidEMail BIT       IF @Email IS NOT NULL             SET @Email = LOWER(@Email)            SET @ValidEMail = 0            IF @Email LIKE '[a-z,0-9,_,-]%@[a-z,0-9,_,-]%.[a-z][a-z]%'               AND @Email NOT like '%@%@%'               AND CHARINDEX('.@', @Email) = 0               AND CHARINDEX('..', @Email) = 0               AND CHARINDEX(',', @Email) = 0               AND RIGHT(@Email, 1) between 'a' AND 'z'                       SET @ValidEMail = 1          RETURN @ValidEMail  END

devx-admin

Share the Post: