All,

I'm using SQL Select to retrieve data from a few tables where one of the field in the cursor is "month".

Example,
03/98
04/98
06/98
02/99
06/99

For that, I need to put the order as,
ORDER BY SUBSTR(month,4,2),SUBSTR(month,1,2)

However, this cannot be done because ORDER BY need to refer to a field, but not SUBSTR(...).
Any solution or good idea to this??

Thanks,
Gan