Reference Guide
>
TDV Support for SQL Functions
>
Numeric Functions
>
SIGN
SIGN
The SIGN() function returns the sign of a number.
Syntax
SIGN(number)
Example
SELECT SIGN(-2.56)
Returns -1