Link Search Menu Expand Document

SIGN

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

Syntax

SIGN(<value>)

Parameters

Parameter Description Supported input types
value Any 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: | If | Returns | | :– | :—— | | <value> < 0 | -1 | | <value> = 0 | 0 | | <value> > 0 | 1 |

SIGN(5)

Returns: 1

SIGN(-1.35E-10)

Returns: -1

SIGN(0)

Returns: 0