+

A leading plus sign indicates that this word must be present in each row that is returned.

-

A leading minus sign indicates that this word must not be present in any of the rows that are returned.

(no operator)

By default (when neither + nor - is specified) the word is optional, but the parts that contain it are rated higher.

( )

Parentheses group words into subexpressions. Parenthesized groups can be nested.

*

The asterisk serves as the wildcard operator. Unlike the other operators, it should be added to the END of the word to be affected. Words match if they begin with the word preceding the * operator.

"

A phrase that is enclosed within double quote (“"”) characters matches only parts that contain the phrase literally, as it was typed.

EXAMPLES:

The following examples demonstrate some search strings that use boolean full-text operators:

' butterfly valve ': Find parts that contain at least one of the two words.

' +butterfly +valve ': Find rows that contain both words.

' +butterfly valve ': Find rows that contain the word “butterfly”, but rank parts higher if they also contain “valve”.

' +butterfly -valve ': Find rows that contain the word “butterfly” but not “valve”.

' valve* ': Find rows that contain words such as “valve”, “valves”.

' "Dry disconnect adapter" ': Find rows that contain the exact phrase “Dry disconnect Adapter” (for example, rows that do not contain “Dry disconnect coupler”).