Description

Returns TRUE if all patterns are found

Syntax

HAS_ALL_VALUES(v1, v2[, v]*)

●      v1: target value

●      v2+: patterns or lookup values

Example

Given Color is a multi-valued lookup into the Colors table with values {[Red], [Green], Blue]} and [Red] is a record in the Colors table:

HAS_ALL_VALUES(Color, [Red])             ® TRUE

HAS_ALL_VALUES(Color, [White])          ® FALSE

HAS_ALL_VALUES([Red], Color)            ® FALSE

HAS_ALL_VALUES( [White], Color)        ® FALSE

Note

If target and pattern are the same lookup types then the Ids are used otherwise it uses the string-based FIND for a positive match.