Sorting with an alpha numeric field.

[Jacque Scott]

I need to create a query that will sort by a alpha numeric field.  I
need the ID field returned and one problem that I will face is that when
it sorts in alpha numeric the ID field will be out of sequence.  I will
use this ID field in another part of the program so I need to make sure
I get all of the ID.
 
Thanks,
 
Jacque