SIGN

The SIGN() function returns the sign of a number.

Syntax

SIGN(number)

Example

SELECT SIGN(-2.56)

Returns -1