select
*
from
yourtable
order
by
cast
(yourcol
as
int
);
select
*
from
yourtable
order
by
convert
(
int
,yourcol);
select
*
from
yourtable
order
by
cast
(yourcol
as
int
);
select
*
from
yourtable
order
by
convert
(
int
,yourcol);