The OR search operator
You can use an OR operator to search for multiple types of results in a given property. For instance, if you are looking for contacts in your database that are located in Boston or New York, you can enter your search so that City | contains | "Boston" OR "New York":
Please note that the OR operator must be in all capital letters. You can also combine an OR operator search with a wildcard search using the * search function. For instance, if you want to filter freemail addresses, you can build a filter that looks like this:
The AND search operator
The AND search operator is used to search for multiple values within a single property entry. For instance, if you want to search for all results that have both hello and gmail.com in the email, try a search like this:
Please note that the AND operator must be in all capital letters. With this filter, you'll segment out contacts whose email address includes both values, such as email@example.com.