I am trying to sort the list in ascending and descending.
Here in the list I have underscore values also.
When I sort ascending it works fine
(Underscore values (in ascending order) first and then
Alphabets next (in ascending order))
But when I sort descending it gives output like alphabets first and then underscores values. BUT I want to view the list as
Underscore values first (descending order) and then alphabets (descending order).
Can some one please let me know how to make underscore values come first in descending order and the alpha bets in descending order.
Order By Decode(SubStr(my_value,1,1),'_',1,2) asc , my_value desc
Click Here to Expand Forum to Full Width