Sql Server Orderby() error

See more:

SQL-Server

i have a table containing 1 to 121 numbers only.

i want to order it by number

Example

i have a table named tbl_numbers having only one field number
the filed number contains 1 to 121 numbers consecutively

i want to show it like
1
2
3
4
5
6
7
8 etc

i used this query

select number from tbl_numbers order by number


its showing like this

1
10
11
12
13
2
3
4
5
6
7
8
9 etc

that is it is jus ttaking the first digit only..



can anyone help me to solve this?

it will be a great one

Kishore R