>>I tested this out and the two SQL statements return the same set of values on my machine.
>
>

---

Oh far worse, machine or OS dependant ? I tested it with many simple tables with values ranging from 1 to just 10. I use under w2k, maybe ? Speed (Athlon650 with 196Mb)? Thanks for trying.
>Cetin

I should have specified!

I used tables with 1000 records - that shouldn' make a difference.

Environment is VFP 6.0 SP3 in W2K, Pentium II-300 w 128MB RAM. I can't think of anything about the environment (except possibly version of VFP) that could make a difference. Maybe a Fox setting that's causing the difference?