Updating 1/2 of column?

Question

Good day,

I am trying to clean up some data from a previous SQL database. I have a column that contains email addressed for employees. There are around 1200 employees. The domain name recently changed for the email address and I need to change just the @anywhere.net portion of the email address.

Is there a way to globally change all of the @anywhere.net to @thisplace.gov? Would it be easier to add a new column with the @thisplace.gov contained within? That however, doesn't solve the problem of still needing to globally change all 1200 email addresses in the email column... Any hints?

Tom

Answer 1

0

update EmployeeTable
set email = replace(email, '@anywhere.net','@thisplace.gov')

If you want to see the results before the update runs try

select
   email,
   replace(email, '@anywhere.net','@thisplace.gov')
from EmployeeTable

answered Nov 18 '09 at 08:41 PM

Kev Riley ♦♦
46.1k ● 39 ● 43 ● 69

Kev , excellent thank you

Sep 27 '11 at 02:21 AM mickyd

(comments are locked)

Updating 1/2 of column?

Follow this question

Related Questions