Comparison operators

Operator

Description

Grid pane

=

Equal.

= 'Smith'

<>
!=

Not equal to.

<> 'Active'

>

Greater than.

> '01 Jan 2024'2

<

Less than.

< 100

>=
!<

Greater than or equal to.

>= 'T'

<=
!>

Less than or equal to.

<= '01 Jan 2024' 2

BETWEEN expr1
AND expr2

Tests range of values.

BETWEEN 

'01 Jan 2024' 

AND 

'31 Dec 2023'2

IS [NOT] NULL

Tests whether contents of column is null.

IS NULL

[NOT] LIKE

Performs pattern matching.

LIKE ('MAC%')

ANY (SOME)

Tests whether one or more rows in the result set of a subquery meet the specified condition.

<> ANY (subquery)

ALL

Tests whether all rows in the result set of a subquery meet the specified condition.

advance > ALL (subquery)

[NOT] EXISTS

Tests whether a subquery returns any results.

EXISTS (subquery)