Re: if then else statement on 2 columns in SQL query?

You could try to create a duplicate decode nested structure. Except for any of the final results replace 'Oranges' with the sort order '1'

Like this:

  Decode (Col_1, 'O' , 'Orange', decode... ...) Data,   Decode (Col_1, 'O' , 1 , decode... ...) Sort_Order
.
.

  Order by Sort_Order

Think this will work?

--
Ken Madsen Received on Mon Oct 19 1998 - 15:15:22 CDT