Returns the smallest integer greater than or equal to the numeric value passed to this function. For example, if you pass 3.14 to CEIL, the function returns 4. If you pass 3.98 to CEIL, the function returns 4. Likewise, if you pass -3.17 to CEIL, the function returns -3.

Integer if you pass a numeric value with declared precision between 0 and 28.

Double value if you pass a numeric value with declared precision greater than 28.

NULL if a value passed to the function is NULL.

The following expression returns the price rounded to the next integer:

You can perform arithmetic on the values passed to CEIL before CEIL returns the next integer value. For example, if you wanted to multiply a numeric value by 10 before you calculated the smallest integer less than the modified value, you might write the function as follows: