>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.
censored.