Related Documentation Download this Manual
PDF (US Ltr) - 0.6Mb
PDF (A4) - 0.6Mb


HeatWave User Guide  /  ...  /  Comparison Functions and Operators

11.2.4 Comparison Functions and Operators

The following table shows supported comparison functions and operators. The VARLEN Support column identifies functions and operators that support variable-length encoded string columns. See Section 3.3, “Encoding String Columns”.

Table 11.3 Comparison Functions and Operators

Name VARLEN Support Description
BETWEEN ... AND ... Yes Check whether a value is within a range of values
COALESCE() Yes Return the first non-NULL argument. Not supported as a JOIN predicate.
= Yes Equal operator
<=> NULL-safe equal to operator
> Yes Greater than operator
>= Yes Greater than or equal operator
GREATEST() Yes Return the largest argument.
IN() Yes Check whether a value is within a set of values
IS Test a value against a boolean
IS NOT Test a value against a boolean
IS NOT NULL Yes NOT NULL value test
IS NULL Yes NULL value test
ISNULL() Test whether the argument is NULL
LEAST() Yes Return the smallest argument.
< Yes Less than operator
<= Yes Less than or equal operator
LIKE Yes Simple pattern matching
NOT BETWEEN ... AND ... Yes Check whether a value is not within a range of values
!=, <> Yes Not equal operator
NOT IN() Yes Check whether a value is not within a set of values
NOT LIKE Yes Negation of simple pattern matching
STRCMP() Yes Compare two strings.