Query Help    University of California Museum of Paleontology
Back to: UCMP Administrative Forms

  1. Matching Null and Blank Values in a field
    To match records that have a blank or null value in a field, choose "equals" and then type "null" into the box as the value to match.

    Example Find records where loc_prefix is blank, and loc_suffix is "--".
    Loc Prefix
    Loc Suffix

  2. Using "or" to match multiple values in a field
    To create a query that matches more than one value in a field by using the pipe symbol ("|") between the values you want to match.

    Example find records where Type is either "fig" or "publ"

Please read the UCMP copyright notice and disclaimer before using UCMP records in analyses or reports.

Search Specimens   •   Specimens (advanced)   •   Search Localities   •   Photos   •   About the Catalog   •   Notice and Disclaimer
UCMP Home   •   UCMP Collections   •   BSCIT   •   Berkeley Natural History Museums