>>replace customer.name with ... in customer
>
>If I can had a nickle for every trick I learn from UT, I'd be a millionair, or, at least I wouldn't have to work anymore. :)
>
>thanks.
Now that they've told you how to make it work, I'll tell you why it sometimes doesn't work (without the IN clause). If the current table is not positioned on a record, (ie: sitting at EOF()), the replace will not take place even if both tables involved in the replace are at the correct position. So if your current table was at EOF(), no REPLACE would work.