Previous Topic

Next Topic

RoundUp - SQL Function

RoundUp(Number: Number[, Decimals: Number]): Number

Rounds Number upwards (that is, away from zero) to the number of decimal places specified in Decimals, range for Decimals is maximum 9, minimum -6.

If decimals is omitted, 0 is assumed and RoundUp rounds to an integer. Rounding up to 10, 100, 1000 and so on may be achieved with negative decimals.

RoundUp function syntax has these named arguments:

Parameter

Description

Number

Required. Number to be rounded up.

Decimals

Optional. Number of decimal places to round Number up to.

See Also

SQL Number Functions

Book Contents

Book Index