Solved

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

Posted on 2010-11-17
2
178 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

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

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

733 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