ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-29
Expressions and Operators
Expressions and Operators
Use Transact-SQL syntax in expressions when using the NonStop ODBC Server.
The syntax of an expression is:
Operators are summarized on the following pages.
The syntax of a Boolean expression is:
Table 4-10
summarizes the supported and unsupported Transact-SQL operators.
operand operator operand [ operator operand ] ...
operand is:
{ constant }
{ column-name }
{ function }
{ ( subquery
) }
{ variable }
operator is:
[ arithmetic-operator ]
[ bitwise-operator ]
[ string-operator ]
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