Returns 1 if expression is positive, -1 if expression is negative, or zero if expression is zero.

Syntax

SIGN ( expression )

Notes

expression must evaluate to a NUMERIC data type.

Example

This example illustrates the SIGN function:

SELECT SIGN(-14) 'Sign' FROM MYMATH;

Compatibility

ODBC compatible