>>>Unless I'm blind (which is almost true) there's no mention
>>> of IN in the VFP docs.
>
>>IN (Value_Set)
>> FieldName must contain one of the values or expressions specified in Value_Set for inclusion in the query results. When listing items in the value set, separate each item with commas.
>
>>IN (Subquery)
>> FieldName must contain one of the values returned by Subquery for inclusion in the query results.
>
>Is this from VFP9 help? In VFP8's help I don't see those 2 references.

Interesting - I can see those quotes in "SELECT - SQL Command", example 7 and 8 in my Vfp8 CHM version.

In the VFP9 help, they also occur in "Changes in Functionality for the Current Release", "Filter Conditions for Queries and Views", "SELECT - SQL Command - FROM Clause", "SELECT - SQL Command - WHERE Clause", and "SQL Language Improvements"


-Stefan