Last post Dec 22, 2014 01:57 PM by JoyceW
Dec 22, 2014 01:40 PM|venkimca|LINK
Hi friends ,
I am new to sql , i have to update 1800 rows column data in one of the table. The data string will be like below ..
In the above string D:\_definst_\thisfiles\myfile\2013 this is common path for all the columns data in each row. Now i have to change the file path from 2013 to 2014 in all the records. Please let me know how can i update these all
records in a single query.
Dec 22, 2014 01:57 PM|JoyceW|LINK
Put in your table name and your column name.
Update YourTableHere set YourColumn = replace(YourCollumn,'\2013\','\2014\')
You can test this first by doing: Select replace(YourCollumn,'\2013\','\2014\')