Revision: 56499
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at March 31, 2012 05:21 by klovera
Initial Code
UPDATE [TableName] SET [ColumnName] = Replace([ColumnName],'OldText','NewText')
Initial URL
http://amrsaafan.blogspot.com/2008/08/how-to-replace-text-in-sql-server-table.html
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
MySQL