Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.snowflake.com/sql-reference/functions/boolnot below:

Website Navigation

• Reference
• Function and stored procedure reference
• Conditional expression

BOOLNOT | Snowflake Documentation

Categories:

Conditional expression functions

Computes the Boolean NOT of a single numeric expression. In accordance with Boolean semantics:

• Non-zero values (including negative numbers) are regarded as True.

• Zero values are regarded as False.

As a result, the function returns:

• True if the expression is zero.

• False if the expression is non-zero.

• NULL if the expression is NULL.

See also:

BOOLAND , BOOLOR , BOOLXOR

SELECT BOOLNOT(0), BOOLNOT(10), BOOLNOT(-3.79), BOOLNOT(NULL);

+------------+-------------+----------------+---------------+
| BOOLNOT(0) | BOOLNOT(10) | BOOLNOT(-3.79) | BOOLNOT(NULL) |
|------------+-------------+----------------+---------------|
| True       | False       | False          | NULL          |
+------------+-------------+----------------+---------------+

Copy

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4