Address: 1234 Main Street, Sometown, USA
address = mainwill match a record containing the field shown in the example above.
address = (center main)will match an address containing either 'main' or 'center'. Furthermore:
(address location) = (main center)will match either a field called 'address' or a field called 'location' containing either 'main' or 'center'.
Color: Whiteand another record contains:
Color: Red, White, and Bluethe following search text:
color = !Whitewill match the first record, but not the second record.
If it is desired to use one of these characters literally as part of the matching text, the character should be entered twice for each desired occurance of the character in the matching text.
Spaces and new lines cannot be matched literally. Instead, an underscore can be used, which will match one or more space(s), new line(s), or punctuation.