Replace a text in SQL Server Table Column - MySQL Snipplr Social Repository

Revision: 56499

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

Choose a language for easy browsing: