Posted by deane.barker on 07/28/06 05:44

Consider this SQL:

SELECT my_field FROM my_table WHERE my_field IN ('value2', 'value1',
'value3')

Simple enough, but is there anyway to specify that the result should be
ordered exactly like the "IN" clause states? So when this recordset
comes back, I want it like this:

my_field
------------
value2
value1
value3

Possible?

Deane

• Next in forum: optimising the following query
• Prev in forum: query optimisation
• Thread view: Ordering results by order of the "IN' clause

[Reply to this message]