ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-26
Expressions and Operators
The syntax of a Boolean expression is as follows:
Table 3-6 summarizes the supported CORE SQL operators.
Arithmetic operators in an expression are evaluated according to their order of
precedence. The following list of operators is arranged in descending order:
expression comparison-operator [ ANY ] expression
[ ALL ]
expression [ NOT ] IN expression
[ NOT ] EXISTS expression
expression [ NOT ] BETWEEN expression AND expression
expression [ NOT ] LIKE expression
NOT expression LIKE expression
expression IS [ NOT ] NULL
NOT boolean-expression
boolean-expression AND/OR boolean-expression
[ NOT ] boolean-function
Table 3-6. NonStop ODBC Server Support of CORE SQL Operators
CORE SQL Operator Type Symbol NonStop ODBC Server Support
Arithmetic + x
-x
*x
/x
Comparison = x
<> x
Comparison > x
>= x
<x
<= x
+, – (unary operators)
*, / multiplication, division
+, – addition, subtraction