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 ...

How does one accomplish this? I tried using a function in the ORDER BY clause, but SQL syntax doesnt seem to allow parenthesis in the ORDER BY clause. I've seen articles for using a case statement ...