>Hi Brien, George and Bill,
>I came to an interesting point and I think everybody should be aware of this situation (BTW I added it to my list of BUGS). Before I forget Bill, everything including set collate are at their VFP default (machine).
>-If right side has a regular index or no index then both SQLs return the same n records set.
>-If right side has a candidate or primary index on that field then second SQL returns 0 records (if you make it 0x7FFFFFFF then both return the same set)
Cetin,
Nice catch! Rather disconcerting, but good to know.
Brien R. Givens
Brampwood Systems