# SIGN

This function returns 1 if the argument is positive, -1 if it is negative, and 0 if it is 0.

## Syntax

```sql
SIGN ( expression )

```

## Arguments

* expression: any valid numeric expression.

## Return Type

Integer.

## Examples

```sql
SELECT SIGN(6), SIGN(-6), SIGN(0);

```

```output

+---------+----------+---------+
| SIGN(6) | SIGN(-6) | SIGN(0) |
+---------+----------+---------+
|       1 |       -1 |       0 |
+---------+----------+---------+

```

***

Modified at: February 24, 2023

Source: [/db/v9.1/reference/sql-reference/numeric-functions/sign/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/numeric-functions/sign/)

(An index of the documentation is available at /llms.txt)