SQL CLR Function for Email validation and string Split

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

umailedit SSCrazy Points: 2087 More actions · Answer 1

"[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]+$

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 2

SSC Guru

Points: 76202

May 17, 2016 at 12:52 pm

Thanks for the script.

Cookies on SQLServerCentral