Re: IN clause with more than 999 elements

Pete Finnigan wrote:

>Hi Federica
>
>Put the >999 elements into a table and change to a sub select
>
>select * from table where field in (select field from listtable);
>
>hth
>
>Kind regards
>
>Pete
>
>

And if the elements are dynamic, you didn't say, use a global temporary table and learn how they work so you use the correct type for what you are doing..

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)