Contents Index Bitwise operators Search conditions

UltraLite Database User's Guide
  Dynamic SQL
    Dynamic SQL language elements
      Operators

Operator precedence

The precedence of operators in expressions is as follows. The operators at the top of the list are evaluated before those at the bottom of the list.

  1. Names, functions, constants

  2. ()

  3. unary operators (operators that require a single operand): +, -

  4. ~

  5. &, | , ^,

  6. *, /, %

  7. +, -

  8. ||

  9. Comparisons: >, <, <>, !=, <=, >=, [ NOT ] BETWEEN, [ NOT ] IN, [ NOT ] LIKE

  10. Comparisons: IS [NOT] TRUE, FALSE, UNKNOWN

  11. NOT

  12. AND

  13. OR

When you use more than one operator in an expression, it is recommended that you make the order of operation explicit using parentheses rather than relying on an identical operator precedence in UltraLite.


Contents Index Bitwise operators Search conditions