From what I've been able to gather, using REGEXP_SUBSTR could be a way to go, but I just don't know Regular expressions well enough to do anything useful.

Is it possible to order by a substring in a returned field ... I can't think of how I'd do this in SQL, but before I give up and just write code to deal with it, can someone else come up with ...