>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?
Steven,
The badgno is not very well formatted for that
If the form of the badgeno is the same everywhere
select left(badgeno,3), ;
val(substr(Badgeno,4)), ;
from TheTable ;
into cursor TheCursor ;
order by 1,2
Gregory