Filter operators

Contact extended detail fields have drop-down lists that allow you to filter Contacts using operators depending on whether the fields are text strings or numeric or dates:

Operators for Strings fields
You can use the following operators to search for extended detail fields whose values are strings:
  • starts with searches for Contacts whose value for this field begins with the value specified.
  • is empty searches for Contacts who have no entry for this field.
  • is not searches for Contacts who do not have this value (excludes Contacts with this value).
  • = searches for Contacts whose fields matches the value specified exactly.
Operators for numeric or date fields
You can use the following operators to search for extended detail fields whose values are numeric or dates:
  • = searches for Contacts whose fields matches the value specified exactly.
  • is empty searches for Contacts who have no entry for this field.
  • is not searches for Contacts who do not have this value (excludes Contacts with this value).
  • < searches for Contacts whose value for this field is less than the value specified.
  • <= searches for Contacts whose value for this field is less than or equal to the value specified.
  • > searches for Contacts whose value for this field is more than the value specified.
  • >= searches for Contacts whose value for this field is more than or equal to the value specified.
When you chose <, <=, >, or >=, a second drop-down list appears that allows you to define a range of values.