
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 protected]’, @Email) = 0