`ARRAY_CONTAINS`
Data 360 Query Guide, mirrored from developer.salesforce.com: **Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API
markdownreferencev125BR-HPR6guide: data-cloud-query-guidestage: referencetrust: officialsource: developer.salesforce.comservice: data360interface: sql`ARRAY_CONTAINS`Data 360Data CloudData 360 Query Guide
Mirror of <https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array-contains.html> (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers.
ARRAY_CONTAINS
Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API
Checks whether a specified value is present in an array.
<array>: The array to search.<value>: The search value.
Returns a boolean value (true or false) that indicates whether the value is present in the array.
- The value must match the element type of the array.
- Comparison is exact and case-sensitive for strings.
Check whether a value exists in an array.
Returns true because 3 is present in the array.
Check whether a value is present in an array.
Returns false because 2 isn’t present in the array.