字段名 Qty 字符型
值 1/3
目的想把1/3转换成0.333333,然后进行计算
---------------------------------------------------------------
select f1,f2,f3,case when CHARINDEX('/',f2) =0 then convert(int,f2) else convert(int,substring(f2,1,CHARINDEX('/',f2)-1)) /
convert(int,substring(f2,CHARINDEX('/',f2)+1,LEN(f2)))
*f3 end as sum from table1