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