Returns -1 if a number is less than 0, 0 if a number is 0, or 1 if a number is greater than 0.

Syntax

---

SIGN(<NumericExpression>)

<NumericExpression> =

Type of:

SMALLINT
INTEGER|INT
BIGINT
FLOAT
DECIMAL|NUMERIC

Returns

---

INTEGER

Usage

---

The SIGN function returns -1 if a number is less than 0, 0 if a number is 0, or 1 if a number is greater than 0.

SQL 2003 Standard Deviations

---

This function deviates from the SQL 2003 standard in the following ways: