» Documentation » SQL Reference

Comparison operators

These are only valid in search clauses (ie. WHERE) when doing SELECT, UPDATE and DELETE on tables. Numerical, date and varchar data types are all acceptable for these comparators. Text and blob values cannot be used with comparative operators. Varchar values are compared character by character according to the codepage of the database.

Operator

Description

<

Less than

<=

Less than or equal to

==

Equal to

!=

Not equal to

<>

Not equal to

>

Greater than

>=

Greater than or equal to