Query Help

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 "P".
Loc Prefix
Loc Suffix
Searching for records with any value in a field (not null)
To match records that DO NOT have a blank or null value in a field, choose "equals" and then type "notnull" into the box as the value to match.
Example Find records where elevation is recorded.
Elevation
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"
Type

BSCIT University of California, Berkeley