>I want to sort character data with letters coming before numbers:
>
>AA
>A1
>A2
>BR
>BZ
>B2
>B8
>1A
>11
>12
>2A
>2B
>
>How would I go about this?

You can use this index

index on CHRTRAN(myField,'0123456789',CHR(170)+chr(171)+CHR(172)+chr(172)+CHR(173)+ ;
CHR(174)+ CHR(175)+CHR(176)+CHR(177)+CHR(178)+CHR(179)) tag SpecSort