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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. njcraig

    Need an SQL statement for a selective update

    I am definitely not worthy! J:\COP153\ and \\172.21.2.7\ddsi\COP100\52\ is what is entered in the field named ImagePath. What I want changed is \\172.21.10.1\COP153\ and \\172.21.10.1\ddsiCOP100\52 There are diferrent paths in the fields so I only want to change the J: and \\172.21.2.7 and...
  2. njcraig

    Need an SQL statement for a selective update

    Not really set yet but I am grateful for your help I tried to run that SQL but nothing changed in the Field? I ran this: update images set imagepath = concat('\\172.21.10.1' , substring(imagepath,3)) where imagepath like 'J:\%'; I don't understand the substring comment?
  3. njcraig

    Need an SQL statement for a selective update

    I want to change J: whatever is after J: I would like to leave alone and replace J: with \\172.21.10.1\mugshots Thanks again
  4. njcraig

    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...

Part and Inventory Search

Back
Top