>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?
If it's not broken, fix it until it is.
My Blog