How to query for valid email address with _@_._ format?

#1 (**permalink**) 12-05-2006, 05:20 AM

How do I query for emails from a table with right format of _@_._ e.g Example@Test.com

#2 (**permalink**) 12-11-2006, 08:50 PM

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))

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

User Name		Remember Me?
Password

vBulletin Message

Cancel Changes

How to query for valid email address with _@_._ format?

ANSWER(S):