How to order "table of contents" type numbed data
I have a column in a table called toc_number of type varchar2(20). The data in this column is the number part of a table of contents. I need to know if there is a way to write a query which sorts this data correctly.
Example Data sorted correctly:
9.9
9.9.1
9.9.2
...
9.9.9
9.9.10
9.9.11
If you just use the "asc" or "desc" it doesn't sort correctly. It comes out like:
9.9
9.9.1
9.9.10
9.9.11
...
9.9.2
9.9.21
Thanks,
Amy
0