>>>>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?
>>>
>>>SELECT * FROM master_table WHERE ASCAN( aCompanyNames, company_name ) # 0
>>>
>>>This assumes that you are not too worried about optimization, that capitalisation is not an issue, etc.
>>Hi Houston:
>>my code is...
>>select company_name from mymaster where ascan(myarray)
>>This is not working...
>>
>>I need my array called myarray to be used in the WHERE CLAUSE.
>
>For aCompanyNames read myarray - if you are using myarray as a variable name you are in the wrong occupation - IMO!
Hi Houston, I am not using aCompanyNames as a variable name. I am using
an array with myarray[1],myarray[2].myarray[3],etc...