question

mickyd avatar image
mickyd asked

update email address

Morning everyone. Can anyone please up me with a requirement to update all email addresses contained in a table. Current email address for example is : joe.smith@yahoo.com and I want to change all entries with yahoo.com to gmail.com etc. So new addresses will be joe.smith@gmail.com thanks for any advice. MD
tsql
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image
Tim answered
Check out [replace]( http://msdn.microsoft.com/en-us/library/ms186862.aspx). This should do the trick for you.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered
See also this question
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.