October 15, 2002 at 11:49 am
I just noticed that a lot of our newsletter subscribers seem to have had their emails mixed up by our server, so I now seem to have alot of these:
ahoo.comXXXXXX@!2000@yahoo.com
Anyone know of a good way to remove all the 'ahoo.com's at the begining of the emails w/o removing the ones at the end. I could do it manually I guess, but I'm feeling lazy. Thanks!
October 15, 2002 at 11:50 am
woops, ignore the 2 @ signs in the email, i put that in there by mistake.
October 15, 2002 at 12:04 pm
If the ahoo.com is always at the beginning and always the same length then something like this should work:
UPDATE tablename SET email = RIGHT(email,len(email) - 8)
WHERE LEFT(email,8) = 'ahoo.com'
Robert W. Marda
SQL Programmer
bigdough.com
The world’s leading capital markets contact database and software platform.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply