dcsimg
LinkedIn
Twitter
RSS Feed
Download our iPhone app
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

 



   
Email AuthorEmail Author
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date