image\Dql_0023.gifceil

Type

Math Function

Purpose

The ceil function rounds up a numeric value to the next integer.

Syntax

ceil( NUMERIC VALUE)

Returns

An integer value.

Usage

The numeric value in a Math function can be a constant value (as shown below), a variable, a field value or an expression.

Examples

 ceil(5.000)

Returns:5

 

 ceil(5.001)

Returns:6