Using the Null Keyword

You can use the null keyword to search for records that contain blank fields with null values. In form fields, a null value appears as an empty field in which no value has been specified.

You can use the null keyword in these areas of the application:

  • Filter-in-Place mode
  • Query form searches
  • Saved filters

The null keyword cannot be used for searches of field values in a collection (Edit > Find Value in Collection).

To do a null keyword search:

  • In Filter-in-Place mode, specify null in any field in which you can type characters.
  • In query forms, you can use the null keyword in any of the primary criteria or additional criteria fields that use the = (equal) or <> (not equal) operator.
Note: 
  • To find records where a particular field is not blank (null), specify <>null
  • The null keyword is not case-sensitive.
  • To perform a search in which a field might contain, in whole or in part, the word "null," enclose it in asterisks (*null*).
Related topics