SQL UPdate Replace语法

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