ARRAY_OVERLAP

Test whether two arrays share at least one element.

Category: collection

Description

Returns TRUE if the two arrays share at least one common element. Useful for filtering rows where any tag or category matches a target set. If either operand is NULL, the result is NULL.

Open in interactive docs →   DeltaForge home →