Use the equals sign to perform an exact word search. Your search will retrieve records with this word exactly anywhere in the field you are searching on, with no stemming (ie. =roast will NOT retrieve: roasted, roaster, roasting, roasts, etc.). Equals is the only operator that disables stemming, which otherwise occurs by default.

starts with If a field begins with this word, the record will be retrieved. Stemming occurs automatically.

ends with If a field ends with this word, the record will be returned. Stemming occurs automatically.

matches This allows you to build your own query using any or all character operators:

space (AND)

|

-

=

" "

^

$

is This wraps a ^ (caret) and a $ (dollar sign) around your search. If you search only one word, a field must begin and end with that word in order for the record to be retrieved. Stemming occurs automatically.

Examples: [Brand] is Kong - retrieves records where the brand is "Kong" exactly, but excludes records where the brand is Kong Company or The Kong Company.