I am wanting to round up my values at query time to 0 decimal places from 2 decimal places. I have
SELECT DISTINCT b.vSeries_Table_Number, b.vSeries_Number, b.vSeries_Geography, b.vSeries_Type, b.vSeries_Unit_Type, a.Variable_Date, ROUND(a.Variable_Value, 0) AS 'Value'
but the output still has the 2 decimal places which are 0s and pointless in a report. This should word but for some reason is not. Any ideas?