Very basic would be: SELECT EmailAddress, CASE WHEN EmailAddress LIKE ' %_@_%_.__%' AND EmailAddress NOT LIKE '%[any obviously ...
www.google.com.tw