[SQL Server] Find & Replace within a Single Field in a Table

access_time Tuesday, February 25, 2014 4:11 pm
account_circle Andy Boot

UPDATE Table

SET NavLink = REPLACE(CAST(NavLink AS NVarchar(MAX)), ‘OLDTEXT’, ‘NEWTEXT’)

WHERE (NavLink LIKE ‘%OLDTEXT%’)