>>>IN is for use with subqueries. Use INLIST or $ for lists of items...
>>
>>Does it mean that "in (item1, item2, item3)" is not pure SQL? I've used that instead of InList() just because I'm trying to avoid Fox's internals in SQL - though it may be a long time before I stumble over FoxSQL vs RealSQL compatibility issues.
>
>No, I think IN is really supposed to work for lists of items, and is a more standard SQL way than INLIST or $ - it just doesn't work in vfp yet :)
Bruce,
Agree. I don't know why but though it's more ANSI SQL "in (list)" just doesn't work with Fox all the time (except examples where there are few items in list).
Cetin