Return to Snippet

Revision: 56499
at March 31, 2012 05:21 by klovera

Initial Code
UPDATE [TableName]
SET [ColumnName] = Replace([ColumnName],'OldText','NewText')

Initial URL

Initial Description
If you have a Table which has a Column of type char or varchar or even text, and you want to change a portion of text in it for example a path. In this case you need to change the same text with new one in every records.

Initial Title
Replace a text in SQL Server Table Column

Initial Tags
replace, text

Initial Language