Hi John,
>
> I have an application where a user can choose a large number of distinct products to process.
>
> The SQL that I currently use looks something like this:
>
> select * from products where date='01012000' AND ( id='123' OR id='456' OR id='789' );
>
> There can be maybe hundreds of different unconnected id's chosen.
>
> Is there a more elegant/efficient way to do this than a large number of ORs ?
You could try
AND id in ('123','456','789');
--
Rob
He who dies with the most toys ...
... still dies