sql½«varcharÀàÐÍת»»ÎªIntÀàÐÍÅÅÐò

select * from Tb

where 1=1 and IsNumeric(Tb.a) = 1 order by cast(Tb.a as int) asc

IsNumeric(Tb.a) = 1 ---->ɸѡ×Ö¶ÎaÄÜת»»ÎªintÀàÐ͵ÄÊý¾Ý

order by cast(Tb.a as int) asc ------->½«aת»»ÎªintÀàÐͽøÐÐÅÅÐò