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?