SIGN function

The SIGN numeric function tells you whether a given number is positive, negative, or zero.

Syntax

The SIGN function returns -1, 0, or +1 when the NumericExpression value is negative, zero, or positive respectively. The parameter can be any built-in numeric data type and the result is of the same type as the parameter. If the parameter is NULL, the result is NULL

Related concepts
ESQL

Related tasks
Developing ESQL

Related reference
Syntax preference
ESQL numeric functions