Returns the smallest integer greater than or equal to expression.

Syntax

CEILING ( expression )

Notes

The expression must evaluate to a numeric data type.

Example

This example illustrates the CEILING function:

SELECT CEILING (32.5) 'Ceiling'
     FROM SYSPROGRESS.SYSCALCTABLE;

Compatibility

ODBC compatible