Simple Full Text Queries

Simple Full Text Queries are those queries that contain only simple search terms and one single logical operator. Simple Full Text Query is the most efficient and fastest method of searching - if somewhat less precise in the pool of returned records. For example, one could search the Ultra-Staff Resumes database with the following search terms and logical operators:

WORD AND EXCEL AND POWERPOINT

Note the single logical operator AND.  The query, although "perfectly logical" and "understandable" to most people would actually return unexpected records - such as resumes containing the words:

WORD-PROCESSING AND EXCELLENT COMMUNICATION SKILLS AND POWERPOINT

On the other hand, a query containing the following search terms and logical operators:

MICROSOFT WORD AND MICROSOFT EXCEL AND POWERPOINT

Would only return records containing those terms, and possibly also records containing the words:

MICROSOFT WORD97 AND MICROSOFT EXCEL AND POWERPOINTS

It is also easy to understand that a simple search using a full sentence such as "REGRESSION ANALYSIS WITH MULTI-NESTED MODELING"... would greatly restrict the number of returned records.