Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Partial String Update

Status
Not open for further replies.
philwes83170

philwes83170

MIS
Mar 4, 2003
47
0
0
US
I need to make a mass change to a field that contains an email address. Values are standard format (joe@company.com, sally@company.com, etc). I need to change all the endings to @newcompany.com. The table holds about 500 records so I would like to write an update statement to do this.

Not being a very proficient SQL User though I'm not sure how to just replace the company.com part. Help....
 
Sort by date Sort by votes
Replace is your friend.

Code: 
Update Table
Set    EmailAddress = Replace(EmailAddress, '@company.com', '@newcompany.com')

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Update with a month name 1
Replies
9
Views
287
gmmastros
gmmastros
Auguy
  • Locked
  • Question
Connection String in .NET program Config File 2
Replies
10
Views
230
Auguy
Auguy
TheBugSlayer
  • Locked
  • Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks 2
Replies
10
Views
281
gmmastros
gmmastros
leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
134
Chris Miller
Chris Miller
ahmedsa2018
  • Locked
  • Question
How to display part number based on search string by chemical id ?
Replies
3
Views
108
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top