Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Functions : CEILING
 

CEILING

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