>>>Perhaps with the selfsame command, but adding an index on the key expression - an index on dtos(dTraBan) + cRefBan..., especially in the historical file.
>>
>>Thanks Hilmar. Tried and didn't seem to help much.
>>
>>Alex
>
>Other options include an outer join, and doing a SET RELATION to the history table (copy those that have something like eof("HistoryTable")). I am not sure whether any of these options would be faster.

Hilmar and Naomi,

I am going to add a column with a hash of the others and compare the hashes. Looking for hash function...

Alex