请教个SQL问题

[cyh837]

case when grouping(b.proid)=1 then '合计' else proid end

上面的代码中，proid是int类型，所以执行总是提示
“将 varchar 值 '合计' 转换为数据类型为 int 的列时发生语法错误。”

请问这句sql应该怎样写才不出错？
谢谢！

[csdyyr]

case when grouping(b.proid)=1 then '合计' else rtrim(proid) end

[华夏小卒]

case when grouping(b.proid)=1 then '合计' else ltrim(proid) end

--try 

[lihan6415151528]

cast(proid as int)

[--小F--]

case when grouping(b.proid)=1 then '合计' else rtrim(proid) end 

case when grouping(b.proid)=1 then '合计' else cast (proid as int) end 

case when grouping(b.proid)=1 then '合计' else convert(int,proid) end

[--小F--]

---错误,修改下
case when grouping(b.proid)=1 then '合计' else rtrim(proid) end 

case when grouping(b.proid)=1 then '合计' else cast (proid as varchar(20)) end 

case when grouping(b.proid)=1 then '合计' else convert(varchar(20),proid) end

[xuejiecn]

case when grouping(b.proid)=1 then '合计' else rtrim(proid) end