SIGN

SIGN (expression)

Parameters

• expression - any valid numeric expression.

Description

Return -1 if the value is smaller 0, 0 if zero, and otherwise 1.

Example

Gets a sign for every value:

SELECT name, SIGN(VALUE) FROM Player;