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

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