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

Thanks Fred.
JimB has explained it to me most elegantly.