Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL CLR Function for Email validation and string Split Expand / Collapse
Author
Message
Posted Wednesday, December 22, 2010 9:45 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 14, 2013 3:48 PM
Points: 444, Visits: 162
Comments posted to this topic are about the item SQL CLR Function for Email validation and string Split
Post #1038591
Posted Saturday, December 25, 2010 1:12 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, May 27, 2016 4:29 PM
Points: 395, Visits: 236
"[a-z]+[0-9]*@\w+[.](com|com.uk|com.np|net|com.in)$"

This is not enough to validate all emails, try this:

[a-zA-Z0-9]+([-\._][a-zA-Z0-9]+)*@(\w+(-\w+|_\w+)*\.)+[a-zA-Z]+$
Post #1039190
Posted Tuesday, May 17, 2016 12:52 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 26, 2016 7:20 AM
Points: 7,816, Visits: 753
Thanks for the script.
Post #1787026
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse