Link Search Menu Expand Document

This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.

CONTAINS

Returns whether the array passed as the first argument contains the value passed as the second argument.

Syntax 

CONTAINS(<array>, <value>)

Parameters

Parameter Description Supported input types
<array> The array to be checked for the given element. ARRAY
<value> The element to be searched for within the array The array elements’ type

Return Type

BOOLEAN

  • Returns true if the element to be searched is present in the array
  • Returns false if the element is not present in the array

Example 

SELECT
	CONTAINS(['sabrina21', 'rileyjon', 'ywilson', 'danielle53'], 'danielle53');

Returns: true as “danielle53” is part of the array.

CONTAINS returns false when the value is not contained in the array:

SELECT
	CONTAINS(['sabrina21', 'rileyjon', 'ywilson'] , 'danielle53');

Returns: false as “danielle53” is not part of the array.