Select - Binary: Search

The Search template appears in template list when a binary field, of type varbinary, has been picked in the Select pane.  The template selects based on binary values compared to the given value.

 

Search

Select by testing the number of bytes in the binary data value in the source field compared to the given value or values,  which can be values from a field, a specified value, or the result of an expression that evaluates to a numeric value.

 

  • between - Select records with the number of bytes in the binary value between the At least and At most values, inclusive.
  • equal (=) - Select records with the number of bytes in the binary value equal to the given value.
  • greater (>) - Select records with the number of bytes in the binary value greater than the given value.
  • greater or equal (>=) - Select records with the number of bytes in the binary value greater than or equal to the given value.
  • less (<) - Select records with the number of bytes in the binary value less than the given value.
  • less or equal (<=) - Select records with the number of bytes in the binary value less than or equal to the given value.
  • not equal (<>) - Select records with the number of bytes in the binary value not equal to the given value.

 

If we would like to select records that are NOT variations of the above, for example not between, select on the basis of one of the above and press Ctrl-I or Edit - Select Inverse to invert the selection.   Selecting using between and then pressing Ctrl-I is the equivalent of "not between" the given values.

 

Launch the template by choosing a binary field in the Select pane and then double-clicking the Search template.  When the template launches we can specify options.

 

 

Search : between

Select records with the number of bytes in the binary value between the At least and At most values.

 

Search : equal (=)

Select records with the number of bytes in the binary value equal to the given value.

 

Search : greater (>)

Select records with the number of bytes in the binary value greater than the given value.

 

Search : greater or equal (>=)

Select records with the number of bytes in the binary value greater than or equal to the given value.

 

Search : less (<)

Select records with the number of bytes in the binary value less than the given value.

 

Search : less or equal (<=)

Select records with the number of bytes in the binary value less than or equal to the given value.

 

Search : not equal (<>)

Select records with the number of bytes in the binary value not equal to the given value.

 

 

See Also

Select - Binary

 

Select - Binary: Expression

 

Select - Binary: Null

 

Select Reference

 

Select - Expression