   |
   |
|
Comparative Operators
|
|
|
|
These are only valid in search clauses (ie. WHERE) when SELECTing, UPDATEing and DELETEing 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 |
Related