| How to check format of emailid is correct or not in SQL Query?
To check this query we have created a table and put 5 rows where 3 are correct and 2 are wrong as given below now we will run different query on this table
(1)SELECT * FROM tbltestEmailId WHERE emailid LIKE '%_@__%.__%' AND PATINDEX('%[^a-z,0-9,@,.,_,\-]%', emailid) = 0
(2)select * from tbltestEmailId where emailid not like '%[^a-z,0-9,@,.]%' and emailid like '%_@_%_.__%'
Output of above query is
Now other query that will print incorrect emailid
(3)SELECT emailid AS NotValidEmail FROM tbltestEmailId WHERE NOT emailid LIKE '%_@__%.__%' AND PATINDEX('%[^a-z,0-9,@,.,_,\-]%', emailid) = 0
| | |