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 vote288 views3 answers
CONTACT FORM SQL
SQL
11 votes290 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
21 votes288 views1 answer
SQL cheat sheet pdf
SQL
0 vote267 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote275 views1 answer
Remove transient options sql wordpress
SQL
3 votes310 views3 answers
Create table in SQL Server
SQL
0 vote264 views1 answer
Oracle create table auto generated primary key
SQL
1 vote279 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote263 views1 answer
C# select Mysql
SQL
0 vote284 views1 answer
Login failed for user sql server
SQL