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
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.