Sign

Sign() returns 1, 0 or -1 depending on whether x is a positive number, 0, or a negative number.

Syntax:  

Sign(x)

Return data type: numeric

Limitations:  

If no numeric value is found, NULL is returned.

Examples and results:  

Examples Results

Sign( 66 )

Returns 1

Sign( 0 )

Returns 0

Sign( - 234 )

Returns -1