sign

Syntax

sign(numeric)

Parameters

• numeric – is any exact numeric (numeric, dec, decimal, tinyint, smallint, int, or bigint), approximate numeric (float, real, or double precision), or money column, variable, constant expression, or a combination of these.

Examples

• Example 1 – Returns the sign for -123:

  select sign(-123)

  ----------- 
          -1

• Example 2 – Returns the sign for 0:

  select sign(0)

  ----------- 
           0

• Example 3 – Returns the sign for 123:

  select sign(123)

  ----------- 
           1

Usage

Results are of the same type, and have the same precision and scale, as the numeric expression.

See also Transact-SQL Users Guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute sign.