Logical and comparison operators

These operators are supported:

  • AND
  • BETWEEN
  • IS NULL
  • IS NOT NULL
  • LIKE
  • NOT LIKE
  • OR
  • GREATER THAN using the > character
  • GREATER THAN OR EQUAL TO using the >= characters
  • LESS THAN using the < character
  • LESS THAN OR EQUAL TO using the <= characters
  • ANY
  • ALL
  • SOME

Do not use the syntax of single quotes with or without spaces to evaluate NULL and NOT NULL conditions.

This query syntax produces unreliable results:

  • =''
  • =' ' <>''
  • <>' '

Wildcard characters using % and _ are supported. Wildcard characters using [ ] and [^ ] are not supported.

Compass data values are case-sensitive. Values ‘abc’ and ‘ABC’ are not equal.

Compass queries, in general, compare strings to integers and vice versa, for comparisons such as WHERE order_number = 123 or order_number= '123'.