Re: Very long "WHERE" list.

Mikito Harakiri apparently said,on my timestamp of 11/07/2004 4:07 AM:

>
>
> And the winner is:........ Drumroll................
>
> My SQL!
>
> According to their doc the number of values in the IN list is only
> limited by the max_allowed_packet value.

Good. Then I suggest the OP uses MySQl. I wish him/her luck in using linear searches with 20000 elements for efficient code...

Ah yes, there is a difference between theoretical SQL statement size and real supported size. Which is why I repeat the question:

Which database supports EXACTLY and PRECISELY the code as posted by the OP?

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam