如何将字符型的1/3转换成浮点型的0.33333

字段名 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

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus