>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
Try
SELECT SUBSTR(Month,4,2) AS Year, SUBSTR(Month,1,2) AS Month FROM MyTable ORDER BY Year, Month
or if you're happy with EXP_1, EXP_2 as field names
SELECT SUBSTR(Month,4,2), SUBSTR(Month,1,2) FROM MyTable ORDER BY 2,1
Charlie