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

3 votes220 views2 answers
Sql paging query
SQL
0 vote227 views1 answer
Foreign key type uniqu mysql
SQL
0 vote234 views1 answer
Query for backup a database at another location in file system
SQL
0 vote208 views1 answer
Dapper run sql script with parameters
SQL
1 vote226 views1 answer
Oracle undo usage per session
SQL
0 vote241 views1 answer
SQL check if record exist
SQL
1 vote215 views1 answer
Sql to mongodb query converter
SQL
7 votes286 views2 answers
Drop index oracle
SQL
17 votes222 views6 answers
Get last record in sql
SQL
0 vote226 views1 answer
Dump db only triggers mysql
SQL