CEIL Function

The CEIL function takes as its argument a numeric expression, or a string that can be converted to a DECIMAL data type, and returns the DECIMAL(32) representation of the smallest integer that is greater than or equal to its single argument.

The following query returns 33 as the smallest integer that is larger than or equal to the CEIL argument of 32.3:
SELECT CEIL(32.3) FROM systables WHERE tabid = 1;
The next example returns -32 as the smallest integer that is larger than or equal to the CEIL argument of -32.3 :
SELECT CEIL(-32.3) FROM systables WHERE tabid = 1;