The LIKE comparator is used somewhat like the "=" comparator except that it supports the wild cards in the following table. This allows it to filter the column for fields whose contents begin with, end with, or include the value that you specify.
Wild card |
Explanation |
% |
any string of zero or more characters |
_ |
any single character |
[ASDF] |
any single character within the set of values that you specify |
[^ASDF] |
any single character not within the set of values that you specify |
The LIKE comparator is case sensitive. String values should be enclosed in single quotations marks. To filter for values that do not contain the specified criteria, use NOT LIKE.
In the following example, only data where the company name contains the word "Market" will pass the filter and be acted upon by the query.
In the following example, only data where the company name ends with the word "Market" will pass the filter and be acted upon by the query.
In the following example, only data where the contact name begins with a name such as "Elizabeth" or "Elisabeth" will pass the filter and be acted upon by the query.
In the following example, only data where the contact name begins with either "Elizabeth" or "Elisabeth" will pass the filter and be acted upon by the query.