[AccessD] Sorting Alpha-Numerics

Gustav Brock gustav at cactus.dk
Tue Oct 21 10:10:31 CDT 2003


Hi Mark

> Oooh...that is a little closer Gustav.  You must be on the right track.
> That approach put 001 through 019 in order before jumping to 01A.

Of course ... StrComp returns -1 for that 01A.

This should do:

  Order By Abs(StrComp(strVal, Cstr(Val(strVal)), 1)) ASC, strVal ASC

/gustav


> You could do this SQL

>  .. Order By StrComp(strVal, Cstr(Val(strVal)), 1) ASC, strVal ASC

> /gustav


>> Greetings,

>> I have a text field containing all possible 3 digit alpha-numeric 
>> combinations from 000 to ZZZ.  I am looking for a method to sort this 
>> text field where 000 through 999 are listed in numerical order before 
>> the remaining alpha-numeric combinations are listed in ASCII sort 
>> order.  Any suggestions?  I have tried to do this in Excel, however, 
>> Excel makes some startling decisions on its own...such as turning 7E9 
>> into 7000000000.

>> Example:
>> 000
>> 001
>> .
>> .
>> 998
>> 999
>> 00A
>> 00B
>> .
>> .
>> ZZZ



More information about the AccessD mailing list