>>Can you build a WHERE CLAUSE using an array in a SELECT statement? I have a table with a field called company_names. I need to code a SELECT statement with a WHERE CLAUSE that pulls out all the records that are in my array... example...SELECT * FROM master_table WHERE company_name =(all the elements in my array) INTO mycirsor...
>>This should give me a cursor with all company_names that are in my array...any ideas?
>

---

>Create cursor mycomp and append data from array
>

>CREATE CURSOR mycomp (comp_name C(nn))
>APPEND FROM ARRAY myarray
>
>SELECT * FROM master_table WHERE company_name
>  IN (Select comp_name FROM mycomp )
>  INTO mycursor
>

Hi Sergey:
for some reasons the code is only getting the first element of the array
and does not append the whole array into a cursor...am I doing something
wrong?