Forum Discussion
Sequential serial numbers do not come up in sequence
I have a number of areas for whom I raise Penalty Notices, and want them to show in sequntial order. When i trip over 9 into 10, it then sequences after the #1 number, and not after the #9 ...
If with sql,
//select * from basic_order_by_natural;
select * from basic_order_by_natural order by number COLLATE NATURAL_CMP ;