Oracle SQL character data need sorted numerically
Posted on 2013-01-31
I have a column in my database that has data that begins with numbers but can have letters, that is why it is a varchar field. For example, 1, 1a, 2, 2a, 3, 3a, 4,5,6, 7, 8, 9 10
I need to sort it in ascending order, but it sorts like the following:
How can I get it to do that.????