Operators in Full-Text Searches: AND, OR, NOT, and NEAR
5/10/2007
With the AND, OR, NOT, and NEAR operators, you can refine your search. The following table shows how to use each of these operators.
| Search item | Example | Results |
|---|---|---|
Both terms in the same topic |
dib AND palette - or - dib & palette |
Topics containing both the words dib and palette. |
Either term in a topic |
raster OR vector |
Topics containing either the word raster or the word vector. |
The first term without the second term |
ole NOT dde |
Topics containing the word OLE but not the word DDE. |
Both terms in the same topic, close together |
user NEAR kernel |
Topics containing the word user within eight words of the word kernel. |