4.9.2.73 SIGN function (ODBC compatible)

Syntax

SIGN ( expression )

Description

The scalar function SIGN returns 1 if expression is positive, -1 if expression is negative, or zero if it is zero.

Example

SELECT SIGN(-14) 'Sign'
     FROM SYSTPE.SYSCALCTABLE;

Notes

• expression must evaluate to a numeric data type.