Thursday, November 25, 2010

Replace Command in Update Statement ( Sql Server 2005)

UPDATE dbo.authors
SET city = replace(city, 'Salt', 'Olympic')
WHERE city LIKE 'Salt%';