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.

mnewnham commented Apr 10, 2016 A new method 'substr' that provides a portable SQL substring statement, in particular overcoming the SQL server requirement for a mandatory 3rd length parameter ...