Seems that the T-SQL supports what I'm trying to do, but whatever SQL crystal is using doesn't like the expression I'm using for the substring length. If I hard-code the substring length it works ...

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