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
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
