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