No worries Mate <s>.

>Yea, yea...that's it. I can do that.
>Hey, thanks a lot Mate! (:-)
>
>
>>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?