Replace all pathfield with chrtran(pathfield,'U:\','U:\QuestPDM\'


>I have a table with 7000 + records in. One of the fields is named path. Stored in this field is a path to where a file is. A typical list of the dir would read:
>
>U:\neil\neil.png
>U:\neil\peter.png
>U:\data\data.png
>U:\reports\report.frx
>
>Whe have added a new parent directory in and moved all the files into this directory. therefore I would like to change the path so the following above would read:
>
>U:\QuestPDM\neil\neil.png
>U:\QuestPDM\neil\peter.png
>U:\QuestPDM\data\data.png
>U:\QuestPDM\reports\data\report.frx
>
>I basically want to precede the beginning of the path with QuestPDM. Can anybody help me in how to do this.
>
>Many Thanks