#convert string to Decimal / Float value and make sum without round problem SUM(cast(moneyFiled as DECIMAL(10,4))) as moneyFiled # money or float ...