Built-In Functions and Syntax › Next Integer Equal or Higher

Next Integer Equal or Higher

The next integer equal or higher function returns the smallest integer that is equal to or greater than a numeric value.

Syntax:

►►─┬─ NEXIH ─────────┬─ (value) ──────────────────────────────────────────────►◄
   ├─ @CEIL ─────────┤
   ├─ NEXTINTEH ─────┤
   └─ NEXT-INT-EQHI ─┘

Invocation names:

@CEIL
NEXIH
NEXTINTEH
NEXT-INT-EQHI

Parameters:

(value)

Specifies the numeric value to be rounded up to the next integer.

Example:

This example raises a balance due amount to the next higher dollar value. The initial value of BALANCE-DUE is 453.29.

select nexih(balance-due) as 'Balance-due' from invoice

  BALANCE-DUE = 454