Embedded SQL: ORDER BY

["Phil" <sublime78ska@xxxxxxxxx>]

In sql/400, is there a way to sort based on a substring of a field like
this:

    select * from myfile order by substr(myfield,1,2)

I've only been able to do it if I explicitly include the new field

    select substr(myfield,1,2) from myfile order by substr(myfield,1,2)

the bummer being that I have to also explicitly include all other columns
that I need.

Phil


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---