Purpose
Returns -1, 0, or 1, to indicate that a specified number is negative, zero, or positive (respectively). You can issue this statement from the MapBasic window in MapInfo Pro.
Syntax
Sgn( num_expr )num_expr is a numeric expression.
Return Value
Float (-1, 0, or 1)
Description
The Sgn() function returns a value of -1 if the num_expr is less than zero, a value of 0 (zero) if num_expr is equal to zero, or a value of 1 (one) if num_expr is greater than zero.