Please try:

Index On Iif(IsAlpha(State),Left(State,1)+Padl(Trim(Substr(State,2)),9),Padl(Trim(State),10)) to tmp

Here I assume there will only be 1 alphabetic character. If this is not the case, please tell me.

Ben