Null
Select for null values in the source field.
- null - Select records with NULL values.
- not null - Select records with non-NULL values.
Launch the template by choosing a numeric field in the Select pane and then double-clicking the Null template. When the template launches we can specify options.
Null : null
Select records with NULL values.
We begin with an example table for a drawing that contains three areas, two lines and two points. We have used the Layers pane to hide the mfd_id field, for a simpler illustration.
With the focus on the table window, in the Select pane we choose the Height field and then we double-click the Null template to launch it.
In the Null template, for Condition, we choose null.
For Action, we use the default replace selection.
Press Select.
The template selects all records where the Height value is NULL.
Null : not null
Select records with non-NULL values.
We begin with an example table for a drawing that contains three areas, two lines and two points. We have used the Layers pane to hide the mfd_id field, for a simpler illustration.
With the focus on the table window, in the Select pane we choose the Height field and then we double-click the Null template to launch it.
In the Null template, for Condition, we choose non null.
For Action, we use the default replace selection.
Press Select.
The template selects all records where the Height value is not NULL.