order behaviour ?

how can I change order behaviour in 8.1.6 ? with the command 'select col from table order by col' I like to recive number befor character
col

---
1
2
a
A
b
B

is this possible and how to change ?
thx
hannes