>I am trying to use inlist for integer values but I keep getting errors saying invalid oprand/mismatch. Is the following type of query valid?
>
>

>select sub_key.sub_key,sub_vendor from sub_key where sub_key.main_keys = 7450 AND sub_key.sub_key = INLIST(sub_key.sub_key,93,97,352,354,355) into cursor blah
>

>
>thanks
>Nick

Nick,

INLIST() function returns logical true or false.

If you want to select some sub_keys USE IN syntax (SQL Server compatible)

AND Sub_Key.Sub_KEY IN (93,97,352,354,355) into cursor blah