WebData Pro Tutorials: Search Operators

Boolean Operators

WebData Pro supports the Boolean operators AND, OR, NOT. The order of execution is left to right (this order cannot be changed)

Boolean operators within fields

AND is entered as the 3-letter word, between terms that you are requiring be present for a record to be retrieved.

OR is entered as the 2-letter word between terms which at least one must be present, but they need not all be present , for a record to be retrieved.

NOT is entered as the 3-letter word and an exclamation mark initiating the term to be excluded

Boolean operators across fields

To search across multiple fields put the criteria inside 1[ ] as the criteria for the first field(s), and 2[ ] for the second field(s).

Note: this search implies AND. WDP does not support OR search across fields

Truncation

If you wish to search a text or a comment field using truncation, you may enter any part of the word in your search. WebData Pro does NOT require the use of truncation symbols such as *.

The truncation is performed both before and after the word.

For example, to search for the word 'California' in a text field containing names of states, you may enter 'Cal', 'lifo', 'nia' etc. HOWEVER if you enter 'nia' you will retrieve such values as 'Virginia' as well.



A SCHOOL WITHIN THE COLLEGE OF APPLIED SCIENCES AND ARTS