Operators are used to compute values, which may in turn be used as operands in a higher-level expression.

UltraLite SQL supports the following types of operators:

Comparison operators evaluate and return a result using one (unary) or two (binary) comparison operands. Comparisons result in the usual three logical values: true, false, and unknown.

Arithmetic operators evaluate and return a result set for all floating-point, decimal, and integer numbers.

String operators concatenate two string values together. For example, "my" + "string" returns the string "my string".

Bitwise operators evaluate and turn specific bits on or off within the internal representation of an integer.

Logical operators evaluate search conditions. Logical evaluations result in the usual three logical values: true, false, and unknown.

The normal precedence of operations applies.

- Operator precedence
- Comparison operators
- Arithmetic operators
- String operators
- Bitwise operators
- Logical operators

Arithmetic operators

String operators

Bitwise operators

Operator precedence