Solved

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

Posted on 2010-11-17
2
176 Views
Last Modified: 2012-05-10
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
Comment
Question by:CMI_IT
2 Comments
 
LVL 30

Accepted Solution

by:
Reza Rad earned 500 total points
ID: 34157301
update myTable
set email=replace(email,'_','.')
0
 

Author Closing Comment

by:CMI_IT
ID: 34157375
Thank you!  (I'm embarrassed how easy that way, but none-the-less grateful!!)
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Select * from 6 39
Delete from table 6 47
Help with SQL - TOP 10 by date and by group 13 39
Help with simplifying SQL 6 53
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now