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 derfloh 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
Joined
Mar 4, 2003
Messages
47
Location
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 Question
Update with a month name
Replies
9
Views
2K
gmmastros
gmmastros
Auguy
  • Locked
  • Question Question
Connection String in .NET program Config File
Replies
10
Views
1K
Auguy
Auguy
TheBugSlayer
  • Locked
  • Question Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks
Replies
10
Views
1K
gmmastros
gmmastros
leifoet
  • Locked
  • Question Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
538
Chris Miller
Chris Miller
ahmedsa2018
  • Locked
  • Question Question
How to display part number based on search string by chemical id ?
Replies
3
Views
451
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top