SELECT ; LEFT(PADL(timefield,7),2)+RIGHT(PADL(timefield,7),2)+SUBSTR(PADL(timefield,7),4,2) AS timesort,; * ; FROM ; mytable ; ORDER BY ; 1 ; INTO ; CURSOR resultThis will construct a "timesort" field that will consist of the Hour, then the AM/PM part, then the minutes. So 10:45AM will come out "10AM45" and 7:30AM will come out " 7AM30"