SIGN() - Determine sign

Function group: numeric function

SIGN() determines the sign of a numeric value.

---

SIGN ( expression )

---

expression

Numeric expression.
expression may not be a multiple value with dimension > 1.

Result

When expression returns the NULL value, the result is the NULL value.

When expression returns the value 0, the result is 0.

When expression is > 0, the result is 1.

When expression is < 0, the result is -1.

Data type: DECIMAL(1,0)

Examples

SIGN (3,14) returns the value 1.

SIGN (-3,14) returns the value -1.