How can I order rowset in this statement?

[redapple]

In the statement below:
select * from Books where (isbn IN (5, 1, 9))

The numbers in the IN clause are in random order, but that's the order I hope the resultsets return: 5,1,9, instead of 1,5,9. But how should I phrase the Order By clause?

Thanks.

 

[sunila7]

Hi,

Try this query

select *, CASE isbn When 5 THEN 1
When 1 THEN 2
When 9 THEN 3
END orderby
from Books where (isbn IN (5, 1, 9))
Order by orderby

Sunil

 

[redapple]

Thanks so much Sunil!

It worked very well in QA. However I am using this SQL statement in an ASP application. ADO componet doesn't recognize this query and generates an error message when it is processed.

How can I get away from this?

 

[sunila7]

Hi,

what is the error message u r getting


Sunil

 

[redapple]

Sunil,
My mistake, it was a syntax error. The query statement worked well now.

Thanks so much!