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

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

)+'%' ci