In a message to ALL, JEFF BIJWAARD said:
JB> 
JB> two alphanumeric fields.  The first is a unique field that
JB> represents our customer order number and the second is a shipment
JB> release number. Because it is an alphanumerics field, the sort order
JB> is by first place, then second place, etc.  So it the shipment
JB> releases run into double digits, it sorts as 1, 10, 11, 2, 3, 4,
JB> etc.  Does anyone know of a way the change the default sort to treat
JB> the second field so that the listing is in numerical order.
JB>  
JB>         (I know the smart thing would be to change the second field to a
JB> "number", but I was not part of the original setup of the database
JB> and changing 2000 pages of script now is really not an option.)
JB>  
JB>    
Change the data.  Use a "changeto" query to make 1 into 01, 2 into 02,
etc.
Rich
--- 
---------------