Interbase 6 Replace In String And Then Update ???

Discussion in 'Databases' started by tdecker81, Sep 17, 2008.

0
  1. #1
    I have a field which stores the location of a tiff file.

    Example \\PCT01\Images\7\368.TIF

    I need to replace all of them with a new path of \\server01\applications\tsteam\data\Images\7\368.TIF

    I can select them


    SELECT FULLFILEPATH FROM NEWTABLE

    HOW DO I SELECT EACH ONE STRIP THE REPLACE THE PART OF THE STRING I DON"T WANT AND REPLACE IT WITH THE ONE I DO WANT.

    I use MS SQL everyday but cursor and replace aren't supported by Interbase so I'm not sure what I can use to replace part of a string and loop through each record and update it.

    Any help would be great
     
    tdecker81, Sep 17, 2008 IP