How to Replace a text in SQL Server Table Column?

by Dinesh 2014-10-08 18:22:09

Do you want to replace a text in SQL Server table? 

Here is the SQL Statement that do this:
 
UPDATE [TableName] SET [ColumnName] = Replace([ColumnName],'OldText','NewText');

Tagged in:

1467
like
0
dislike
0
mail
flag

You must LOGIN to add comments