Supported SQL-92 Expressions

Supported syntax for SQL references to expression.

SQL references to expression refer to the following syntax, unless indicated otherwise:

{expression binary expression} |{expression [NOT] LIKE expression}|
{unary expression} |(expression) |column |pub.column | literal |parameter |
{function ( expression | * ) } |{ expression { IS NULL | IS NOT NULL } } |
{expression [NOT] IN ( values )} |
{CASE [expression] { WHEN expression THEN expression } [...] [ELSE expression] END}|

Binary

 | * | / | % | + | - | | | < | <= | >= | = | <> | IN | AND | OR

Unary

- | + | NOT