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.
- Ex.1 brown AND green
- Ex.2 brown AND green AND blue.
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
- brown and !white
- !white (if what you want to do is retrieve all the records that do not have the word white in that field)
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
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.