Bookshelf v7.5: Pattern Matching Operators


Operator	Description
*	(asterisk) Wildcard for any number of characters before or after the value entered. Used in combination with LIKE.
?	(question mark) Wildcard for a single character. Used in combination with LIKE.
LIKE	Combine with a string and one or more wildcard characters to find all values with string. For example: [Product Line] LIKE "enti?m" returns records where the Product Line field contains the string "enti?m" such as "The Pentium I Line" and "Pentiums".
NOT LIKE	Combine with a string and one or more wildcard characters to find all values without string.
EXISTS	Finds a value from a multivalue group. EXISTS also finds values in any child of the MVG. For example: EXISTS ([Product Component] = "4 Meg Ram") returns records in which attribute Product Component (an MVG) referred to is a child record with the value "4 Meg Ram".