Contents Index SHORT_ULPLAN function [Miscellaneous] SIMILAR function [String]

ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

SIGN function [Numeric]


Function 

Returns the sign of a number.

Syntax 

SIGN ( numeric-expression )

Parameters 

numeric-expression    The number for which the sign is to be returned.

Standards and compatibility 
Example 

The following statement returns the value -1

SELECT SIGN( -550 )
Return value 

For negative numbers, SIGN returns -1.

For zero, SIGN returns 0.

For positive numbers, SIGN returns 1.


Contents Index SHORT_ULPLAN function [Miscellaneous] SIMILAR function [String]