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 text 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 start with a table with two text fields of type nvarchar. 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 Comments field and then we double-click the Null template to launch it.
In the Null template we choose null as the Condition option.
For Action, we use the default replace selection.
Press Select.
The template immediately selects all records that have NULL values in the Comments field.
Null : not null
Select records with non-NULL values.
We start with a table with two text fields of type nvarchar. 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 Comments field and then we double-click the Null template to launch it.
In the Null template we choose not null as the Condition option.
For Action, we use the default replace selection.
Press Select.
The template immediately selects all records that have non-NULL values in the Comments field.