>>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
>
>I'm not sure what do you mean by ALL caps.
>
>What exact query did you try and what indexes do you have in both tables?

I meant that the source code of the SQL condition is not in mixed case, just to make sure it coincides with index expression. Probably VFP would not be confused, but just in case.

Found another way around problem using SYS(2017) hash. Thank you for the help, Naomi.

Alex