One of the most powerful logical operators available is the NEAR keyword. Thanks to this keyword a full text query can be assembled that can return more precise and relevant results. The NEAR keyword can also be combined with the standard AND & OR operators. Pay attention at the logical paths that may be created. It is strongly suggested that users avoid the combination of the NEAR, AND, OR operators in one single query.
Consider the following query against the Ultra-Staff Resumes database:
WORD NEAR
EXCEL
NEAR
POWERPOINT
The probability of obtaining usable results is very high - especially when considering the format and contents of most Resumes. Please be advised that the NEAR keyword is "overloaded" (a pure technical term): this means that the distance between the words you are searching for is dynamically calculated (usually the distance does not exceed 40 words, except for very large documents containing thousand of printed pages). This feature alone can save a substantial amount of time and effort - when used judiciously.