equals & not equals

The = and <> operations. Compares whether two values are (not) equal.

Syntax

  <value> = <value>
      
  <value> <> <value>

Parameters

<value>: The values to compare

Returns

TRUE: If values are equal (and neither value is null). Or (FALSE in the case of the not equals operator)
FALSE: If the values are not equal (and neither value is null). Or (TRUE in the case of the not equals operator)
NULL: If at least one of the values is null.

Examples

SQL_CONTAINS('foo') AND SQL_CONTAINS('bar')