[AccessD] Sorting Alpha-Numerics

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.



Mark


-----Original Message-----
From: Gustav Brock [mailto:gustav at cactus.dk] 
Sent: Tuesday, October 21, 2003 10:35 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Sorting Alpha-Numerics


Hi Mark

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

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com