>>>>>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
>
>May be you can use CHECKSUM() function? Have you tried my other suggestion, BTW?

I tried your other suggestion, including making fields all caps, but didn't work.

Creating an extra field filled with SYS(2017) and then comparing that field seems to work. I am double checking. Will let you know results.

Thanks Naomi and Hilmar,

Alex