Syntax

SGN(Number)

Description

Returns one of three possible values (-1,0 or 1), depending whether the number is negative, zero, or positive.

Example

SGN (-345) => -1

Number

Numeric expression or data field containing a number.