How to replace a string in a SQL Server Table Column

 

Updating SQL Server table column using REPLACE function

UPDATE TABLENAME
SET COLUMNNAME = REPLACE(COLUMNNAME, 'Old String', 'New String')
WHERE CONDITION

Happy coding…