How to replace a string in a SQL Server Table Column

Question

i have a table (SQL Sever, in this case) which references paths (UNC or otherwise), but now the path is going to change. In the path column, I have many records and I need to change just a portion of the path, but not the entire path. And - I need to change the same string to the new one, in every record.

How can i do this with a simple update?

Answer 1

Its this easy:

update table
set path = replace(path, 'oldstring', 'newstring')

Answer 2

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