» 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.




Less than


Less than or equal to


Equal to


Not equal to


Not equal to


Greater than


Greater than or equal to