Oleg_123 at xuppa.com
Oleg_123 at xuppa.com
Tue Oct 21 09:23:40 CDT 2003
Mike, I just did regular 'sort ascending' got this (I typed it not in any order); is that what u r looking for ? r 000 001 123 134 444 445 455 456 67U AER AQO ASD FGT IUY VBG ZZZ > 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 > > > Mark Mitsules > Senior Designer > Department E13 > Submarine Electrical Engineering > Northrop Grumman Newport News > 757.380.3376 > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com ----------------------------------------- Get Breaking News from CNN, ABC, NBC, CBS Now. http://www.xuppa.com/news/?link=webmail