Advanced Full Text Queries are queries that contain a combination of simple search terms, sentences, phrases, and a mix of logical operators. It is strongly recommended exploring Simple Queries before diving head first into Advanced Queries!
Consider the following query:
WORD 2010 AND
MS WORD
OR
MS-WORD OR
MICROSOFT WORD OR
WORD FOR WINDOWS
AND
EXCEL AND
POWERPOINT
What would be the outcome of this database search? Consider, instead the following query:
WORD 2010 OR
MS WORD
OR
MS-WORD OR
MICROSOFT WORD OR
WORD FOR WINDOWS
AND
EXCEL AND
POWERPOINT
Note how the simple switch of one logical operator dramatically altered the number of records returned and their relevance.
Also sentences, phrases and simple search terms can be combined - as in the following query:
REGRESSION ANALYSIS WITH
MULTI-NESTED MODELING AND
MICROSOFT WORD OR
WORD FOR WINDOWS
AND
EXCEL OR
MICROSOFT EXCEL OR
MS
EXCEL