I have an SQL statement that orders the table in ascending order via the id, but when I do this, the table shows it like:
The order is OK, sql sorts the strings in lexical order.
As 2 (in c-24) comes before 5 (in c-5) it is sorted like that.
If you want to sort stings like this in the numeric order prepend them with zeros.
c-0010 c-0012 c-0012 c-0024 c-0005 c-0006 c-0080 c-0800 c-8000 will be sorted as you want it.