How to replace a string in a SQL Server Table Column

sql sql-server database database-administration

It's this easy:

update my_tableset path = replace(path, 'oldstring', 'newstring')

sql sql-server database database-administration

UPDATE [table]SET [column] = REPLACE([column], '/foo/', '/bar/')

sql sql-server database database-administration

I tried the above but it did not yield the correct result. The following one does:

update tableset path = replace(path, 'oldstring', 'newstring') where path = 'oldstring'

CodeHunter