Page Comparison

space

Fred Smith

Match if a field contains both words in any order. Acts like AND. This search phrase is true for both Fred Smith and Smith Fred.

pipe

Fred | Smith

Match if a field contains either word. Acts like OR. This search phrase is true for Fred or Smith.

spaces and pipe

Fred Smith | Mary Jones

Match if a field contains both Fred and Smith in any order or if the field contains both Mary and Jones in any order.

double quotes

"Fred Smith"

Search for the exact enclosed phrase. This search phrase is true for Fred Smith, but not for Smith Fred. Everything inside double quotes is taken literally. So "|" would search for a pipe. There is no way to search for double quotes.

underscore

Fred_Smith

A single wild character. This would match for Fred Smith, but also matches FredQSmith. A single underscore character can also mean "not null."

percent

Fred%Smith

Multiple wild characters. This would match for FredSmith, Fred Smith, FredQSmith and Fred Jonathan Smith.

circumflex (shift-6)

^Fred
Fred^
^Fred^

Match the beginning or end of a string. Just searching for fred would also match Alfred. In the first example Alfred matches. In the second example, both Fred and Alfred match. In the third example, only exactly Fred matches.

exclamation point

!Fred

Search for anything that does not contain the string. Return all results that do not contain Fred. To exclude multiple values use a row like this:

!Fred !John

blank line

""

Null or empty fields will be returned. Useful if you wanted to find a field that is not filled in.

I recommend entering two double quotes instead though. "" - this is because it is obvious when looking at your filters tab what is going on!