Find and Replace Possible 1

[alexanderthegreat]

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?

exine Water Garage Llc

 

[SQLDenis]

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:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[alexanderthegreat]

Your the best Denis