Sorry, wrong command in my last message, this is correct:
Replace all pathfield with strtran(pathfield,'U:\','U:\QuestPDM\'
>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