---
schema_version: "1"
id: d87ef147e4bad020285e2838e4c469dfa97b43ab717597eb7a30086ec72b502e
title: ARRAY_CONTAINS
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/scalar-func/array-func/array-contains.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array-contains.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: d6c44433fc6de11cdebbe81eb9de35ce33b374570eb5bb6287ef6cc09ccc3080
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# `ARRAY_CONTAINS`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Checks whether a specified value is present in an array.

## Syntax

```sql
array_contains(<array>, <value>)
```

## Arguments

### Required

- `<array>`: The array to search.
- `<value>`: The search value.

## Returns

Returns a boolean value (`true` or `false`) that indicates whether the value is present in the array.

## Considerations

- The value must match the element type of the array.
- Comparison is exact and case-sensitive for strings.

## Examples

### Check for Existing Value

Check whether a value exists in an array.

```sql
SELECT array_contains(array[1, 3, 4], 3) AS contains_three;
```

Returns `true` because 3 is present in the array.

### Check for Missing Value

Check whether a value is present in an array.

```sql
SELECT array_contains(array[1, 3, 4], 2) AS contains_two;
```

Returns `false` because 2 isn't present in the array.

## Related Documentation

- [Array Data Type](https://developer.salesforce.com/docs/data/data-cloud-query-guide/datatype/array.md)