Ask Tom Kyte: varying elements in IN list http://asktom.oracle.com/pls/ask/f?p=4950:8:8321215185943122431::NO::F49 50_P8_DISPLAYID,F4950_P8_CRITERIA:110612348061 or http://tinyurl.com/4u6fc -----Original Message----- Duret, Kathy 8.1.7.4 Solaris 9 What I want to do is build a In list and feed it to a query: select * from test2 where symbol in ( select test_function('IBM') symbol from dual); -- //www.freelists.org/webpage/oracle-l