Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Tuesday, February 04, 2014 1:58 PM
Points: 368, Visits: 215
"[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
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse