sum(cast(replace(upper(col),'NULL','0') as dec(18,2)))
select * from isnumeric(col)=0
sum(cast(col as dec(18,2)))
select sum(case isnumeric(col) when 0 then 0 else cast(col as float) end) from tb
27,579
社区成员
68,558
社区内容
加载中
试试用AI创作助手写篇文章吧