> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/functions-reference/array/array-contains",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Reference material for ARRAY_CONTAINS function

# ARRAY_CONTAINS

Returns `true` if a specified argument is present in the array, or `false` otherwise. Note that `ARRAY_CONTAINS` employs `IS NOT DISTINCT FROM` semantics when comparing values, i.e. `NULL` is considered equal to `NULL`.

**Alias:** `CONTAINS`

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
ARRAY_CONTAINS(<array>, <value>)
```

## Parameters

| Parameter | Description                                     | Supported input types                                           |
| :-------- | :---------------------------------------------- | :-------------------------------------------------------------- |
| `<array>` | The array to be checked for the given element.  | `ARRAY`                                                         |
| `<value>` | The element to be searched for within the array | Any type that can be converted to the element type of the array |

## Return Type

The `BOOLEAN` value `true` if the element to be searched is present in the array, or `false` otherwise.

## Example

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
	ARRAY_CONTAINS(['sabrina21', 'rileyjon', 'ywilson', 'danielle53', NULL], 'danielle53');
```

**Returns**: `true`, since `'danielle53'` is an element of the input array.

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
	ARRAY_CONTAINS(['sabrina21', 'rileyjon', 'ywilson', NULL] , 'danielle53');
```

**Returns**: `false`, since `'danielle53'` is not an element of the input array.

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
	ARRAY_CONTAINS(['sabrina21', 'rileyjon', 'ywilson', NULL] , NULL);
```

**Returns**: `true`, since `NULL` is an element of the input array.