Rounds input value to the nearest integer. Input can be an Integer, a Decimal, a column reference, or an expression. Optional second argument can be used to specify the number of digits to which to round.

NOTE: This function changes the actual data of the value. If you just want to change how the data is formatted for display, please use the NUMFORMAT function. See NUMFORMAT Function.


Numeric literal example:


Output: Rounds the input value to the nearest integer: 3.

Expression example:

round(MyValue + 2.5)

Output: Rounds to the nearest integer the sum of 2.5 and the value in the MyValue column.

Numeric literal example:


Output: Rounds pi to four decimal points: 3.1416.

round(numeric_value, integer_value)

ArgumentRequired?Data TypeDescription
numeric_valueYstring, decimal, or integerName of column or Decimal or Integer literal to apply to the function

Number of digits to which to round.

  • Default is 0, which rounds to the nearest integer.
  • Negative integer values can be applied.


Name of the column, numeric literal, or numeric expression.

Required?Data TypeExample Value
YesString (column reference) or Integer or Decimal literal2.5


Number of digits to which to round the first argument of the function.

Usage Notes: 

Data Type
Example Value
NoInteger literal3

Example - Exponential functions

Example - RANDBETWEEN and PI and ROUND functions