# IS\_BSON\_NULL

Returns a `TINYINT` 1 for nullable BSON input values, and returns a `TINYINT` 0 for other values.

By default, empty values, BSON `NULL`, and BSON `Undefined` are interpreted as nullable.

## Syntax

```
IS_BSON_NULL(<value>)
```

## Argument

`<value>`: A valid BSON value or an expression that evaluates to a valid BSON value.

## Return Type

SingleStore `TINYINT` type.

## Remarks

The following table specifies the value returned by `IS_BSON_NULL()` function for each input value:

| Input Value     | Output Value |
| --------------- | ------------ |
| `NULL`          | 1            |
| BSON`NULL`      | 1            |
| BSON`Undefined` | 1            |
| Any other value | 0            |

## Examples

Here are a few examples that demonstrate the behavior of `IS_BSON_NULL()` function:

```sql
SELECT IS_BSON_NULL(NULL) AS Result;

```

```output

+--------+
| Result |
+--------+
|      1 |
+--------+
```

```sql
SELECT IS_BSON_NULL('null':>BSON) AS Result;

```

```output

+--------+
| Result |
+--------+
|      1 |
+--------+
```

```sql
SELECT IS_BSON_NULL('{"$undefined":true}':>BSON) AS Result;

```

```output

+--------+
| Result |
+--------+
|      1 |
+--------+
```

```sql
SELECT IS_BSON_NULL('"random string"') AS Result;

```

```output

+--------+
| Result |
+--------+
|      0 |
+--------+

```

```sql
SELECT IS_BSON_NULL(1234) AS Result;

```

```output

+--------+
| Result |
+--------+
|      0 |
+--------+
```

***

Modified at: April 4, 2024

Source: [/db/v9.1/reference/sql-reference/bson-functions/is-bson-null/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/bson-functions/is-bson-null/)

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