Local SQL supports the following operators:

Type

Operator

Type

Operator

Arithmetic

+

*
/

 

Logical

AND
OR
NOT

Comparison

<
>
=
<>
>=
<=
IS NULL
IS NOT NULL

String concatenation

||

Note

The equality operator is a single equals sign; double equals are not allowed.