The Help Library / Boolean Operators
Boolean Operators:
Boolean Operators:
And
Narrows search and retrieves records containing all of the fields it separates. In the example above, the AND operator returns only those results which contain both Search Field #1 and Search Field #2.
Narrows search and retrieves records containing all of the fields it separates. In the example above, the AND operator returns only those results which contain both Search Field #1 and Search Field #2.
And Not
Use NOT to exclude a term. Records with the first term will be retrieved, but any records with the second term will be eliminated.
Broadens the search and retrieves records containing any of the fields it separates. In the example above, the OR operator returns all of the results of Search Field #1 and all of the results of Search Field #2 (including those which contain both).
Use NOT to exclude a term. Records with the first term will be retrieved, but any records with the second term will be eliminated.
Broadens the search and retrieves records containing any of the fields it separates. In the example above, the OR operator returns all of the results of Search Field #1 and all of the results of Search Field #2 (including those which contain both).
Using the % symbol expands a search term to include all forms of a root word or number. For example, a search for the term azido and deoxy should be entered as %azido%deoxy%.