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.

• Array Data Type