Mike,
I don't have time for details now but it can (I think).
Cetin

>Thanks for the reply Cetin.
>
>While this idea works for VFP (and SQL Server/Oracle) I'm trying to do this SQL selecting from within the MapObjects2 ActiveX control. If I'm not mistaken, you may know a bit about that control. In particular I'm trying to use the SearchByExpression() method. I don't think it can use joins.
>
>Mike
>
>
>>
>>This ORing might be many and adds to complexity of SQL even if it could ran.
>>When I need such things I simply create a cursor and put values there, make an inner join. ie:
>>
>>create cursor crsTemp (myField i)
>>insert into crsTemp values (1234)
>>insert into crsTemp values (29929)
>>...
>>
>>select .... from myTable mt ;
>>inner join crsTemp lst on val(mt.Myfield) = lst.myField ...
>>
>>Just my .02 cents
>>Cetin