declare @i varchar(10) set @i='0.12%' select cast(left(@i,len(@i)-1)as numeric(8,2)) /*
---------- .12(所影响的行数为 1 行) */select sum(cast(left(ma,len(ma)-1)as numeric(8,2))) from 表
select cast(replace(ma,'%','') as dec(18,2)) from tb 像这样转换后即可.
但我那是在JAVA里..用rs.getString()取应该怎么转!!
selece出来的结果已经是整形了,用 rs.getInt() 即可
String sql="select *from incount where date between '" + id1 + "' and '" + id2 + "' and kfproduct like '%" + id4 + "%' and gysh= '" + id3 + "'"; 假如在这里加怎么加呢???
set @i='0.12%'
select cast(left(@i,len(@i)-1)as numeric(8,2))
/*
----------
.12(所影响的行数为 1 行)
*/select sum(cast(left(ma,len(ma)-1)as numeric(8,2))) from 表
像这样转换后即可.
假如在这里加怎么加呢???