May 25
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%’)
VIT Blog
Visual Impact Tech. Inc. Blog
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%’)
Recent Comments