dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Handy Function to Test for Email Validity

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


advertisement

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

 

Visit the DevX Tip Bank

 



   
Thanks for your registration, follow us on our social networks to keep up-to-date