Advanced Search

Replace a text in SQL Server Table Column

/ Published in: MySQL
Save to your folder(s)
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.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. UPDATE [TableName]
  2. SET [ColumnName] = Replace([ColumnName],'OldText','NewText')

URL: http://amrsaafan.blogspot.com/2008/08/how-to-replace-text-in-sql-server-table.html

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.