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

0 vote179 views1 answer
How to locate pg_hba.conf file
SQL
0 vote173 views1 answer
Get who is hired in february in sql
SQL
-2 votes182 views1 answer
No module named '_sqlite3
SQL
0 vote235 views1 answer
How do you insert boolean to postgresql
SQL
6 votes179 views4 answers
Remove spaces sql server
SQL
0 vote180 views1 answer
Postgres list all triggers
SQL
0 vote166 views1 answer
Psql list view rules
SQL
0 vote200 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote166 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
8 votes161 views2 answers
Update sql server from another table
SQL