>I need to find badge numbers in order. I do select... Order on badgeno. The badgeno is a charactor, 'CNT1','CNT2','CNT3',...'CNT20'. It sorts as CNT1,CNT10,CNT2,CNT20. How can I get this in a numerical order?

Something like

SELECT MYFIELD, VAL(SUBSTR(MYFIELD, 4)) AS Ord;
  FROM Mytable;
  ORDER BY Ord;
  INTO CURSOR...

works