Instructions for Searching
Fill in one or more fields with words or abbreviations of words. The order of the words is ignored. For example sun rain matches we expect both rain and sun and you need sun to have rainbows but not the sun also rises (because there is no rain).
A blank field matches everything; leave all fields blank to match all records.
There is no way to conduct "or" searches (e.g. to match fields that contain rain or sun but not necessarily both).
To match a phrase, enclose it in double quotes, for example "ice cream" matches ice cream cones and ice creams but not cream and ice.
You may also use these special characters:
- @ matches one arbitrary character; for example @rain matches train but not rain or strain
- * matches zero or more arbitrary characters; for example *bow matches bow and rainbow
- = forces the words to be an exact match; for example =sun =rain matches rain and sun but not sunny with rainbows
- < and > work in both numeric and date fields
- // in a date field means "today"
- ? in a date field finds invalid dates or times
- ! finds all records that contain duplicate entries in that field
To find text containing any of these special characters, enclose the text in double quotes. For example use "aname@anaddress" to find the email address aname@anaddress.