Use AND in a search to:
The purple triangle in the middle of the Venn diagram below represents the result set for this search. It is a small set using AND, the combination of all three search words.
Be aware: In many, but not all, databases, the AND is implied.
Use OR in a search to:
All three circles represent the result set for this search. It is a big set because any of those words are valid using the OR operator.
Use NOT in a search to:
Databases follow commands you type in and return results based on those commands. Be aware of the logical order in which words are connected when using Boolean operators:
Truncation, also called stemming, is a technique that broadens your search to include various word endings and spellings.
Similar to truncation, wildcards substitute a symbol for one letter of a word.