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 vote278 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote292 views1 answer
View to table sql
SQL
0 vote299 views3 answers
How to increase size of column in sql
SQL
7 votes305 views6 answers
Mysql group concat
SQL
0 vote292 views1 answer
Mysql where in maintain order
SQL
2 votes269 views3 answers
3 days back in sql server
SQL
65 votes464 views6 answers
Sql add column to table
SQL
5 votes269 views1 answer
Oracle sysdate
SQL
3 votes297 views1 answer
Only join in sql
SQL
0 vote270 views1 answer
Database timezone
SQL