I have an Oracle 10g DB and have a VARCHAR2 (2000 Character) column lets name it TEST which can contain numbers in front for example:
test
1test
3test
When I call "... order by TEST asc" or simply "... order by TEST"
I get the results ordered like
test
1test
3test
But I would like to get the results ordered like this:
1test
3test
test
So the numbered inserts first, is there a method to achieve this?