Set-like Searches Using IN, SUBSET and INTERSECT

The IN, SUBSET and INTERSECT operators can be used for set-like searches on multi-value type fields such as strlst. For example, to find rows where a query term is present in a strlst column, use IN. To find rows where a strlst column contains any of a list of query terms, use INTERSECT to find the set intersection of the row and the query set. To find rows where all query terms must be present in the row, use SUBSET.

• Searches Using IN
• Searches Using SUBSET
• Searches Using INTERSECT
• IN, SUBSET, INTERSECT Commonality