>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
If it's not broken, fix it until it is.
My Blog