REGEX in an Order By clause

[Ed Reed]

How do I use a REGEX expression in the Order By clause?
 
I have a column which contains data that looks like this,
 
A002C
A001
A1000C
B100AA
CAR
A023
 
I use a query like this that sorts everything but the occasional last
aphla character
 
Select field From table Order BY Left(1,field ). Right(field ,
LEN(field )-1); 
 
I would like to add , field REGEXP "[[:alpha:]]$" , to the end of my
Order By clause to handle this problem but its not working.
 
Any thoughts?
 
Thanks