T-sql email validation

IF (
     CHARINDEX(' ',LTRIM(RTRIM(@email_address))) = 0 
AND  LEFT(LTRIM(@email_address),1) <> '@' 
AND  RIGHT(RTRIM(@email_address),1) <> '.' 
AND  CHARINDEX('.',@email_address ,CHARINDEX('@',@email_address)) - CHARINDEX('@',@email_address ) > 1 
AND  LEN(LTRIM(RTRIM(@email_address ))) - LEN(REPLACE(LTRIM(RTRIM(@email_address)),'@','')) = 1 
AND  CHARINDEX('.',REVERSE(LTRIM(RTRIM(@email_address)))) >= 3 
AND  (CHARINDEX('.@',@email_address ) = 0 AND CHARINDEX('..',@email_address ) = 0)
)
   print 'valid email address'
ELSE
   print 'not valid'

Source: stackoverflow.com

Similar codes

4 votes168 views1 answer
Describe table mysql
SQL
0 vote178 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote143 views1 answer
Postgresql get current user name
SQL
0 vote143 views1 answer
Postgresql find missing id
SQL
1 vote145 views2 answers
Mysql spring boot application.properties
SQL
6 votes152 views2 answers
Postgresql restore from dump
SQL
3 votes163 views1 answer
Select sequence oracle
SQL
1 vote169 views1 answer
Second last highest id in sql
SQL
9 votes142 views4 answers
How to remove duplicate in sql
SQL
14 votes150 views1 answer
Excel
SQL