Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Email Validation

Status
Not open for further replies.

syncdba

IS-IT--Management
Nov 28, 2005
206
US
Hi,
I'm working on Data Cleanup. I need to write a sql which will find invalid email addresses.like ex name@somename.com
otherthen this format is invalid emails.
Thanks in advance
 
Use INSTR to look for characters that invalidate an email.
 
I have not used INSTR, but tried a generic message to those emails in our system. We ran it from a dummy email account.
In the end it was not worth the pain, so we had customer service at time of order verify the contacts e-mail each time. A pain for them, but with so many companies neededing e-mail confirmation it was eaiser then generating paper and mailing.

Perhaps it is time well spent after all.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top