Operators in UltraLite

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.

See also

Arithmetic operators
String operators
Bitwise operators
Operator precedence