---
schema_version: "1"
id: 451305834c2ecac7987d008a26d237136cb8f504800e7f906f6274fa1dd5d2b1
title: ARRAY_CONTAINS_ANY
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-any.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array-contains-any.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: da65a8536a30fdd8758d38f9b196dfa5e5f7b3f50a7bc6b0ad597c857687016d
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# `ARRAY_CONTAINS_ANY`

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

Checks whether there's any overlap between two arrays.

## Syntax

```sql
array_contains_any(<array1>, <array2>)
```

## Arguments

### Required

- `<array1>`: The first array to compare.
- `<array2>`: The second array to compare.

## Returns

Returns a boolean value (`true` or `false`) that indicates whether any element exists in both arrays.

## Considerations

- Both arrays must have compatible element types.
- Returns `false` if either array is empty.

## Examples

### Check for Overlap

Check whether two arrays share any common elements.

```sql
SELECT array_contains_any(array[1, 2], array[2, 3]) AS has_overlap;
```

Returns `true` because both arrays contain the value 2.

## Related Documentation

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