Select - Numeric Vectors: Null

The Null template appears in template list when a numeric vector field, that is a field with an ordered set of multiple numbers, of x2 (two numbers), x3 (three numbers), or x4 (four numbers), numeric vector type 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 numeric vector 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.

Null : not null

Select records with non-NULL values.

 

Notes

Numeric vector types - Numeric vectors are fields that have ordered sets of multiple numbers, of x2 type float32x2, float64x2, int8x2, int16x2, int32x2, int64x2uint8x2, uint16x2, uint32x2, uint6x2, of x3 type float32x3, float64x3, int8x3, int16x3, int32x3, int64x3uint8x3, uint16x3, uint32x3, uint6x3, or of x4 type float32x4, float64x4, int8x4, int16x4, int32x4, int64x4uint8x4, uint16x4, uint32x4, uint6x4.   

 

See Also

Select - Numeric Vectors

 

Select - Numeric Vectors: Expression

 

Select - Numeric Vectors: Search

 

Select Reference

 

Select - Expression