>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
George
Ubi caritas et amor, deus ibi est