Returns the sign of a number according to the table below.

​
Syntax

SIGN(<value>)

​
Parameters

ParameterDescriptionSupported input types
valueAny expression that evaluates to a numeric data type.DOUBLE PRECISION

​
Return Type

DOUBLE PRECISION

​
Examples

The following examples highlight what can be returned with the SIGN function:

IfReturns
<value> < 0-1
<value> = 00
<value> > 01

Example

SIGN(5)

Returns

1

Example

SIGN(-1.35E-10)

Returns

-1

Example

SIGN(0)

Returns

0