Prev: Query question with 3 FKs
Next: Table relationship
From: fniles on 6 Jul 2010 15:29
Can I create a query that will replace @abcwest.com with @abcbest.com in the
table Customer column email and cc ?
Thank you


From: Scott Morris on 6 Jul 2010 15:58
"fniles" <fniles(a)pfmail.com> wrote in message
news:%23rGu6FUHLHA.3732(a)TK2MSFTNGP02.phx.gbl...
> Can I create a query that will replace @abcwest.com with @abcbest.com in
> the table Customer column email and cc ?
> Thank you

Yes. Have a look in the BOL index under string functions.


From: Eric Isaacs on 6 Jul 2010 16:04
UPDATE tblCustomer
SET EmailAddress = REPLACE(EmailAddress , '@abcwest.com',
'@abcbest.com') WHERE CHARINDEX('@abcwest.com', EmailAddress) > 0

-Eric Isaacs
 | 
Pages: 1
Prev: Query question with 3 FKs
Next: Table relationship