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
//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