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?
asked Nov 18 '09 at 08:36 PM in Default
If you want to see the results before the update runs try
answered Nov 18 '09 at 08:41 PM
Kev Riley ♦♦