CREATE CURSOR temp1 (cField c(10)) APPEND BLANK REPLACE cField WITH '3' APPEND BLANK REPLACE cField WITH '2' APPEND BLANK REPLACE cField WITH '-1' APPEND BLANK REPLACE cField WITH '9' SELECT VAL(cfield) as xyz FROM temp1 ORDER BY xyzShows, -1, 2, 3, 9 for me.