>Hi!
>
>Insert a list of values into some temporary table before the query. Than use IN (SELECT ...) in youre WHERE clause. In other words, instead of comma-separated list of values provide a SELECT statement.

Hi Vlad,

I can use a local cursor OR table in an SPT statement as a referance? I was not aware of this. I will look into this. I tried something else, I did: CUST.cust_no IN ( listed 20 cust no's ) OR CUST.cust_no IN ( listed 20 more cust no's ) OR CUST.cust_no IN ( listed 20 more cust no's ) etc... This worked, but took way too long. I'll get down to trying what you said. This will take a while.

Thanks
Mike