In this page we have discussed how to validate an email using Java Script : An email is a string (a subset of ASCII characters) separated into two parts by @ symbol. ~ characters are legal in the local part of an e-mail address but in the above regular expression those characters are filtered out. It begins with at least one or more word characters including the underscore, equivalent to [A-Za-z0-9_].
Validating email is a very important point while validating an HTML form. However, there are times where it is handy to use Regex directly from TSQL.There are two Regex engines available to SQL Server. NET Regex requires the creation of CLR functions to provide regular expressions, and works only with SQL Server 2005, (and 2007) See CLR Integration by Christoffer Hedgate. Reg Exp, which are available to SQL Server 2000 as well. The advantage of using CLR is that the regular expressions of the NET framework are very good, and performance is excellent.It's all done in the spirit of 'try it and see...' This Workbench is about using Regular expressions with SQL Server via TSQL.It doesn’t even attempt to teach how regular expressions work or how to pull them together. The aim is to demonstrate a few possibilities and try to persuade you to experiment with them if you don’t already use Regex with SQL Server.