Re: How to get "...WHERE test IN (5,23,2,12,56)" in this order

"Steffen Ramlow" <s.ramlow_at_gmx.de> wrote in message news:a1k2b1$r8kmt$1_at_ID-54600.news.dfncis.de...
> isn't it so that this results in a stmt like this:
>
> SELECT ...WHERE product_id IN (5,23,2,12,56) order by 2;
>
> is this what Dirk wanted?

No, he wanted to sort it so that first appear those with product_id=5, then those with product_id=23, ... Received on Thu Jan 10 2002 - 06:56:25 CST