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.
- UPDATE [TableName]
- SET [ColumnName] = REPLACE([ColumnName],'OldText','NewText')
You need to login to post a comment.