>>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 :)
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.