MS_SQL 查询语句 取出 百分号 的语句%
举例取出商品毛利率,
rtrim(convert(numeric(18,2),((PRICE-OPRICE)/PRICE)*100))+'%'
select shopcode,ProdCode,ProdName,BarCode,DepCode,OPrice,OutOPrice,Price,PRICE-OPRICE MAOLI,rtrim(convert(numeric(18,2),((PRICE-OPRICE)/PRICE)*100))+'%' MAOLILV ,KCCount
from xjy_tmpKCLocate
----rtrim(convert(numeric(18,2),((PRICE-OPRICE)/PRICE)*100))+'%'