General information
Category:
Coding, syntax & commands
Title:
SQL : Can I use Select... Order By SUBSTR(xxxxx) ?
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only