Hi Scott ---
Thats sounds right to me.....the problem lies in Fox's optimization and that's when you get unexpected results.
>
>It's my understanding that a fully optimized query will actually create a filter on the table instead of giving you a separate cursor or dbf(). So, I'm assuming that if you use the NOFILTER clause you will no longer have a fully optimized query, but you will have a cursor that you can then select from. Am I thinking right on this one?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05