|Caveat: The IN operator behaves differently in Texis version 7 and later - it acts more like the new SUBSET operator than INTERSECT. Thus, it is true (matches) if and only if all left-side value(s) are present on the right, not just if any are present (as in version 6 and earlier).|
The version 6 behavior can be restored globally with the inmode
SQL property (or use the INTERSECT operator); it is also
<vxcp compatibilityversion> is set to 6. The
IN operator also utilizes indexes more effectively in version 7,
which is aided by the new indexvalues SQL property.