`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

Created 23 Oct 2026 · Modified 23 Oct 2026 · 1 version

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.

Read this document as markdown — the same bytes an agent receives.