Select - Text: Null

The Null template appears in the template list when a text field of type nvarchar or varchar has been picked in the Select pane.  The template selects records with either NULL or non-NULL values in the source field.

 

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.

 

 

 

 

 

See Also

Select - Text

 

Select - Text: Expression

 

Select - Text: Search

 

Select Reference

 

Select - Expression