Search Help

Fields Searched

1. First name.
2. Last name.
3. Phone.
4. Fax.
5. E-mail.
6. Web site.
7. Notes.

Search Terms

Single word - entering a single word in the search field will return any records with that word.
Example: smith
Returns: all items with the word "smith"

Multiple words - entering multiple words without using logic control words will return records that contain all of the words.
Example: lebowski jeff
Returns: only items that contain each of the words "lebowski" and "jeff"

Multiple words (with quotes) - entering multiple words enclosed in double quotes will retrieve items with those exact words or phrase exactly as entered.
Example: "john smith"
Returns: only items that contain the exact phrase "john smith"

Wildcard (asterisk) - entering a word followed by an asterisk (wildcard) will return records that contain that word or words that have more letters wherever the asterisk is placed.
Example: don*
Returns: only items with the word "don" in them, or variations like "donald" or "donny"

Logic Control Words

OR - search supports the logical "OR" operator. This will search for records that contain either one or both of the search terms on either side of the logic control word.
Example: john or jon
Returns: all records that contain just the word "john" or just the word "jon" or records that contain both

AND NOT - search supports the logical "AND NOT" operator. This will search for all records that, within each single field, contain the first search term, but excludes any items that contain the second search term.
Example: smith and not jane
Returns: any records that contain the word "smith" but do not include the word "jane", within each single field

*Note - special characters (!, #, %, etc.) aren’t searchable by text searches.