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

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

better way is to move to Firebird 2.1 which support REPLACE

REPLACE( <stringtosearch>, <findstring>, <replstring> )
Replaces all occurrences of <findstring> in <stringtosearch> with <replstring>.

select replace(x, ' ', ',') from y;

Firebird 2.1 Release Notes

Does your version of firebird support the Substr and Pos functions?

Substring
How to truncate a string to a certain number of characters?

Pos : I don't know.

but there is POSITION

POSITION See below Returns the start position of the first string inside the second string, relative to the beginning of the outer string. In the second form, an offset position may be supplied so that the function returns a result relative to that position in the outer string.

POSITION( <string> IN <string> )
POSITION( <string>, <string> [, <offset-position>] )