Description

Returns TRUE if any match found

Syntax

HAS_ANY_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_ANY_VALUES(Color, [Red])            ® TRUE

HAS_ANY_VALUES(Color, [White])        ® FALSE

HAS_ANY_VALUES([Red], Color)           ® TRUE

HAS_ANY_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.