除法计算后加%号或者其他字符

select
CONVERT(varchar(10),
cast(10/100.00 as decimal(18,2))

)+'%'

 

 

转载于:https://www.cnblogs.com/liyunchuan/p/11063972.html