-- Along the same lines, this is a very simple way of listing invalid data (allowing -_,;@' in the email column)

DECLARE @match VARCHAR(30)

SET @match = '%[^a-zA-Z0-9@.,;!-!_!'''']%'

SELECT email

FROM tbl_Staff

WHERE email IS NOT NULL

AND email LIKE @match ESCAPE '!'

ORDER BY email