hmm ok well I ended up using substring to return just the last 2 characters as another column and then sorting on that rather then trying to do it all in one step in the order by clause.