dcsimg
 

Submitted by: Hannes du Preez(ojdupreez1978@gmail.com)

Thursday May 17th 2018 by Hannes du Preez

Language: SQL, Expertise: Intermediate - Use this nifty function to check the validity of an email address.

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
Home
Mobile Site | Full Site