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
The normal precedence of operations applies.