>>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?
Brien R. Givens
Brampwood Systems