>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 could do something like:

create cursor c_test (keyvalue C(2))

insert into c_test values('AB')
insert into c_test values('1B')
insert into c_test values('AC')
insert into c_test values('AB')
insert into c_test values('2A')
insert into c_test values('AB')
insert into c_test values('1A')
insert into c_test values('AB')

index on Iif(Isdigit(Left(keyvalue, 1)), 'z', 'a') + Keyvalue tag keyvalue

browse last

where 'z' and 'a' are just whatever characters you want with 'z'>'a'

or for a select statement

select c_test.*, Iif(Isdigit(Left(keyvalue, 1)), 'z', 'a') + Keyvalue as keyvalue from c_test order by keyvalue into cursor c_test2