Keith,
INLIST() and BETWEEN() are optimizable. FoxPro converts these internally to some other syntax.
The Help wording is terrible. I'm sending in a bug report, in case no one has mentioned this already. Thanks for pointing out this poor wording.
>Is there a mistake in the documentation? It reads:
>
>
>You can use BETWEEN( ) or INLIST( ) in the following two forms:
>
>eIndex BETWEEN(eIndex, eExpr, eExpr)
>
>-or-
>
>eExpr INLIST(eIndex, eExpr)
>
>
>What is the leading eExpr?? The SQL syntax lets you:
>
>
>eIndex IN ( eExpr, eExpr, ...)
>
>
>The INLIST() function *is* optimizable isn't it??
>
> ...kt