>You're doing it incorrectly.

>* It's preferable to use IN operator in a query
>...
>AND sub_key.sub_key IN (93,97,352,354,355)
>...
>* or 
>...
>AND INLIST(sub_key.sub_key,93,97,352,354,355)
>...
>

>
>>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

Thank you guys.

Nick