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

1 vote229 views1 answer
Truncate left characters mysql
SQL
0 vote219 views1 answer
Sql offfset
SQL
3 votes231 views5 answers
Mysql get last inserted id
SQL
0 vote233 views1 answer
Kill thread
SQL
0 vote256 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote234 views1 answer
View psql output in horizontal scrolling
SQL
0 vote254 views1 answer
Mysql sum per week
SQL
0 vote239 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
0 vote221 views1 answer
Restore backup "text" postgresql command line
SQL
0 vote244 views1 answer
Renommer base sql
SQL