Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need an SQL statement for a selective update
I have a table with a field called 'imagepath', in this table is data represented by the two following path types: 1. J:\DIR\DIR\DIR and 2. \\172.21.2.7\DIR\DIR\DIRWhat I need to do is udpdate the data to represent the following: \\172.21.10.1\DIR\etc. In other words don't update the dir paths...
