Sacego Sorting Problem

I can't seem to sort the below select by columns 1,2,3,4? The first is an integer and the others are characters. If I sort by 2,3,4, the sort works; but, 1,2,3,4 seems to be ignored. I say ignored, because if I take out the order by clause all together the ouput is the same. The budget unit is 3300 for all 163 rows retrieved (I have it there because some repcodes provide for more than one budget unit), so I would think that the sort would effectively be the same as 2,3,4. But, it isn't? I ran bcheck on all the .dat & .idx files. Any ideas? select A.as_payrate,A.as_retpd,A.as_jobstep,A.as_empnum from assignment A,position P where A.as_enddate = "06/30/93" and P.po_repcode = "U" and P.po_jobcode = A.as_jobcode into temp X; unload to ttt.u select A.as_budgunit,E.em_lastname,E.em_firstname,E.em_midname,E.em_empnum, E.em_lgp,A.as_effdate,A.as_payrate,A.as_jobstep,A.as_retpd,A.as_fac, A.as_reason,P.po_jobcode,P.po_jobtitle,X.as_payrate,X.as_retpd, X.as_jobstep from employee E,assignment A,position P,X where A.as_effdate = "07/01/93" and P.po_repcode = "U" and A.as_enddate = "123199" and A.as_empnum = X.as_empnum and A.as_empnum = E.em_empnum and A.as_enddate = E.em_trmdate and A.as_jobcode = P.po_jobcode order by 1,2,3; Thanks, Bob -- --------------------------------------------------------------------------- |Bob Beaulieu Internet : bobb@netcom.com | |EZ TRAVEL Internet : eztravel@netcom.com | |4640-B Meridian Telephone: (408) 978-0808 | |San Jose, CA 95124 Facsimile: (408) 978-7024 | |+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++| | Serving all your travel needs from start to finish | | $$$ Best Fares $$$ | | Great Service | | Specializing in International Travel | ---------------------------------------------------------------------------