Joe's Knowledge Base - a collection of various tips-n-tricks for SQL Server.
Note: best effort to site sources where applicable, otherwise curated from BOL/MSDN or self-created.
Tuesday, December 18, 2012
SQL for Validate Email
http://stackoverflow.com/questions/229824/tsql-email-validation-without-regex
SELECT
email
FROM #Email
where email like '%[^a-z,0-9,@,.]%'
or email not like '%_@_%_.__%'
No comments:
Post a Comment