MS SQL answer.
Re: How to query for valid email address with _@_._ format?
this may get you part of the way there....
this SQL will display name and email addresse missing an @ sign or a period.
SELECT last_name, first_name, email
FROM [your table]
WHERE (LEN(email) > 0) AND ((CHARINDEX('.', email) = 0) or
(CHARINDEX('.', email) = 0))
|