• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 186
  • Last Modified:

Replacing "_" with "." in multiple data rows

We changed our corporate email address from firstname_lastname@XYZ.com to firstname.lastname@XYZ.com.  As a result, manually updating hundreds-to-thousands of rows of data impractical and time consuming.

What is the best way to programatically update the email addresses?

Thanks!
0
CMI_IT
Asked:
CMI_IT
1 Solution
 
Reza RadCommented:
update myTable
set email=replace(email,'_','.')
0
 
CMI_ITAuthor Commented:
Thank you!  (I'm embarrassed how easy that way, but none-the-less grateful!!)
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now