sqlserverÖн«varcharÀàÐÍת»»ÎªintÐÍ

select * from TableName order by cast(colName as int); 
 
select * from TableName order by convert(int,colName);