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!

Replace

Status
Not open for further replies.
Raul2005

Raul2005

Programmer
Sep 23, 2005
44
US
id code
1 ABC_GB
2 DCF_GB
3 RTF_US

NEED HELP TOto change the records that contain
_GB to _US
 
Sort by date Sort by votes
Update Table Set Code = Replace(Code, '_GB', '_US')


-George

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

Similar threads

Webkins
  • Locked
  • Question
Need to replace FTP with a SQL Server stored procedure... 1
Replies
2
Views
106
johnherman
johnherman
Molkas
  • Locked
  • Question
Replace multiple values on a string with data from another table
Replies
4
Views
76
fredericofonseca
fredericofonseca
earljgray
  • Locked
  • Question
Replace NULL in a SELECT
Replies
4
Views
112
philhege
philhege
bonjourno
  • Locked
  • Question
Replace function doesn't work when I cross reference 2 tables
Replies
4
Views
104
SQLBill
SQLBill
wbodger
  • Locked
  • Question
How to replace compute clause
Replies
5
Views
67
gk53
gk53

Part and Inventory Search

Sponsor

Back
Top