newbie here... need help on UPDATE multiple records in a table
Hello all,
I would like to update all records to reflect the new path (after data migration with path name change) where data is stored.
filed name: "DATA_PATH"
strings:
From: \\Netapp1\L_Drive\CATIA\DB\01\T01200123
To: \\New_netapp\L_Drive\CATIA\DB\01\T01200123
There are about 2000 records to update.
Is it possible to update all records at once with a single SQL statement?
All I want to do is replace the first portion of string "Netapp1" to "New_netapp."
Any info would be appreciated...Thank you in advance!
I would like to update all records to reflect the new path (after data migration with path name change) where data is stored.
filed name: "DATA_PATH"
strings:
From: \\Netapp1\L_Drive\CATIA\DB\01\T01200123
To: \\New_netapp\L_Drive\CATIA\DB\01\T01200123
There are about 2000 records to update.
Is it possible to update all records at once with a single SQL statement?
All I want to do is replace the first portion of string "Netapp1" to "New_netapp."
Any info would be appreciated...Thank you in advance!
0