Hi Im using this sql code to arrange the item ascendingly;

"Select * Table1 Order By ItemCode"

but it display like this..

1
10
2
3
4
5
6
8
9

what code should i write to make it like this?

1
2
3
4
5
6
8
9
10