truncate value to nearest whole number in sql code example
Example: sql limit decimal places
SELECT CAST(ROUND(125.025000, 2) AS NUMERIC(36,2))
returns: 125.03
SELECT CAST(ROUND(125.025000, 2) AS NUMERIC(36,2))
returns: 125.03