Hi Edgar,

How about:

SELECT * ;
    FROM mytable ;
    WHERE myfield IN ( SELECT keyfield FROM paramtable )

Hope this helps,
Gavin...

>You're right. Is as simple as typing it like that.
>Well, I guess I got more confused in this instance, thinking about something I wanted to do couple of weeks similar to this.
>I had in one table values like:
>1
>2
>3
>4....and so on
>
>I wanted to read wherever mixed numbers where coming into the WHERE IN.
>Since there where coming from a table if I put them into an array it would not work in the IN(...) and I did not want to type it up like we are doing here.
>So the how would you do that? I mean, read it in a 'linear' format instead of columnar.
>Does this makes sense or am I confusing you too?
>
>Thanks for answering Gavin
>
>
>Hi Edgar,
>>
>> How about:
>>
>>

>>cParList = "('A','B','C','D')"
>>
>>DO MyProg WITH cParList
>>
>>PROCEDURE MyProg
>>
>>LPARAMETERS pcParList
>>
>>SELECT * ;
>>    FROM mytable ;
>>    WHERE myfield ;
>>    IN &pcParList ;
>>    INTO CURSOR mycursor
>>

>>
>>Hope this helps,
>>Gavin...
>>>>How do I do this?