sql中把varchar类型转换为int型然后进行排序

一、

[sql]

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

适用于SQLServer  Oracle

 

二、

[sql]

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

仅适用于SQLServer

 

数据库中的两个文本类型的信息相加：

update User set U_ZiDuanZhi1=(cast(U_ZiDuanZhi2 as decimal(18, 2)) + cast(U_ZiDuanZhi3 as decimal(18, 2)))

 

 order by cast(ZiDuanZhi1 as int)  将字段变为数字类型进行排序