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