“）”附近有语法错误，这有什么错误啊，没看懂，求大神们看一下

Question

select OperateDt,WorkShopVch, FurnaceNoVch,WeightDbl,TOGNameVch,MasterNameVch,a,
(case when a*100=0 then 0 else convert(varchar ,(a/WeightDbl)*100) +'%' ) as A
from View_YBrokenRecordList

Answer 1

//case then else end 语法不完整，试一下
select OperateDt,WorkShopVch, FurnaceNoVch,WeightDbl,TOGNameVch,MasterNameVch,a,
(case when a*100=0 then 0 else convert(varchar ,(a/WeightDbl)*100) +'%'  end ) as A
from View_YBrokenRecordList