July 30th, 2012, 04:50 PM
Firebird update field in table.
I have a field in a table that contains paths to files, either on my C or on my I drive. I need a procedure to only update my paths for the I drive, f.e. from:
all pathnames can vary. The endresult should always be:
July 31st, 2012, 03:18 AM
Originally Posted by bvleer
UPDATE TABLE_NAME SET
FIELD_NAME = 'II:\' || RIGHT(FIELD_NAME, POSITION('\' IN REVERSE(FIELD_NAME))-1)
UPPER(FIELD_NAME) STARTING WITH 'I:\'