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?