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!

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

Find and Replace Possible 1

Status
Not open for further replies.

alexanderthegreat

IS-IT--Management
Sep 9, 2005
70
US
Is it possible to do a find a replace say for example I want to change all Llc to LLC in my table garages in my field named garagename?

ex:pine Water Garage Llc
 
select replace('Pine Water Garage Llc','Llc','LLC')

update garages
set garagename=replace(garagename,'Llc','LLC')
where garagename like '%Llc' --this assumes it ends with Lic

do a select first to confirm

select garagename,replace(garagename,'Llc','LLC')
from garages
where garagename like '%Llc'

Denis The SQL Menace
SQL blog:
Personal Blog:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top