SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Bharat Panthee / SQL CLR Function for Email validation and string Split / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 05:53:01 GMT20RE: SQL CLR Function for Email validation and string Splithttp://www.sqlservercentral.com/Forums/Topic1038591-2868-1.aspx"[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]+$Sat, 25 Dec 2010 01:12:58 GMTumaileditSQL CLR Function for Email validation and string Splithttp://www.sqlservercentral.com/Forums/Topic1038591-2868-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/T-SQL/71894/">SQL CLR Function for Email validation and string Split</A>[/B]Wed, 22 Dec 2010 21:45:34 GMTBharat Panthee