>If only the data content gets updated (and not the number of records) and if there is a common key that does not get changed by your test run, then things become incredibly simple:

SELECT * FROM TableOne ;
>UNION ;
>SELECT * FROM TableTwo

If the resulting cursor (or table) RecCount() has increased then there are rows with duplicate keys. Do another SQL select where CNT(Key) > 1. This should result in only those records where data has changed - hopefully reducing the work involved in locating the changed data.

---

I was waiting for you to add this Houston. Used it again just yesterday and it works beautifully. Many thanks again.