Difference between revisions of "SIGN()"

From Lianjapedia
Jump to: navigation, search
Line 11: Line 11:
 
The SIGN() function is used to determine the sign of a numeric value.  The SIGN() function will return the following values:
 
The SIGN() function is used to determine the sign of a numeric value.  The SIGN() function will return the following values:
  
{| class="wikitable"
+
{| class="wikitable" width=100%
 
!<expN> Value||Return Value
 
!<expN> Value||Return Value
 
|-
 
|-

Revision as of 12:44, 22 January 2013

Purpose

Function to determine the sign of a numeric value

Syntax

SIGN(<expN>)

See Also

ABS(), IIF(), INT(), ROUND()

Description

The SIGN() function is used to determine the sign of a numeric value. The SIGN() function will return the following values:

<expN> Value Return Value
Positive 1
Negative -1
Zero 0

Example

? sign(9876.78)
         1
? sign(-87.9)
        -1
? sign(0)
         0

Products

Lianja, Lianja Server