T-SQL replace part of a field

SQL Add comments

Replace a word inside the values of a column:
 UPDATE YourTableName SET ColumnAffected =REPLACE(ColumnAffected,’old value’,’new value’) WHERE (ColumnAffected LIKE N’%old value%’)

Leave a Reply

WP Theme & Icons by N.Design Studio
Entries RSS Comments RSS Log in