mysql REGEXP in MS sql server

Question

I am migrating from mysql to MS SQL server. I need to re-factor the below query to be compatible with sql server

SELECT email 
FROM emailexcursions 
WHERE email NOT REGEXP '^[_A-Za-z0-9-]+(\.[_A-Za-z0-9-]+)*@[A-Za-z0-9-]+(\.[A-Za-z0-9-]+)*((\.[A-Za-z]{2,}){1}$)'

REGEXP is not available in sql server, does anyone know a workaround for this?

stackoverflow.com/questions/4105897/mysql-regexp-to-sql-server — mohan111
– mohan111, Commented Nov 20, 2014 at 9:07

i486 · Accepted Answer · 2014-11-20 09:12:44Z

0

You may write external function in C#/DLL and implement REGEXP there. BUT it is better to check the email before storing in DB.

answered Nov 20, 2014 at 9:12

i486

6,5364 gold badges26 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1