ROUND( ) Function

Example   See Also

Returns a numeric expression rounded to a specified number of decimal places.

Syntax

ROUND(nExpression, nDecimalPlaces)

Returns

Numeric

Arguments

nExpression

Specifies the numeric expression whose value is to be rounded.

nDecimalPlaces

Specifies the number of decimal places nExpression is rounded to.

If nDecimalPlaces is negative, ROUND( ) returns a whole number containing zeros equal in number to nDecimalPlaces to the left of the decimal point. For example, if nDecimalPlaces is –2, the first and second digits to the left of the decimal point in the value are 0.

Remarks

The value ROUND( ) returns has the same number of decimal places as nDecimalPlaces. ROUND( ) ignores the number of decimal places specified by SET DECIMALS.