• ⌂ Math
• Functions
  • ABS()
  • CEIL()
  • FLOOR()
  • RAND()
  • ROUND()

CEIL()

Return the value of the evaluated expression rounded up to the nearest integer.

Prototype

integer CEIL(expression expression)

Parameter

• expression - Expression that should evaluate to an integer or decimal number.

Example

SELECT OID, Date, CEIL(Total) AS RoundedTotal FROM Invoice

Return

Value of the evaluated expression rounded up to the nearest integer.

See Also

FLOOR(), ROUND()

• < ISNULL()
• FLOOR() >