Solved

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

Posted on 2010-11-17
2
177 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Record open by another user 6 65
Get row count of current SQL query 8 59
Please help for the below sql query. 1 28
Whats wrong in this query - Select * from tableA,tableA 11 46
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

829 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