The search term must not match text anywhere in the field. Text must follow the search term numerically or alphabetically. Text must precede the search term numerically or alphabetically. Text must match or follow the search term numerically or alphabetically. Text must match or precede the search term numerically or alphabetically.
Right truncation is assumed.
Left truncation is assumed. The search term can appear anywhere in the field. It will attempt to match the word or phrase anywhere in the field. OR Use this operator between two search terms or expressions to select records that match at least one search term. NOT Use this operator before a search term to find all records that do not contain the search term.