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?