先将数据转换为numeric类型,保留4位小数点,由零点几变为百分号前边的数字,再转换为varchar类型,然后再加'%'如：select ml as 毛利,sshje as 实收金额, cast(cast(ml/sshje as numeric(4,4))*100 as varchar(20)) + '%' as 利润率 from chasalldayhz
