Supported SQL-92 Expressions

Syntax that are used to refer SQL reference to expression.

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

{ expression binary expression } |{ expression [NOT] LIKE expression [ESCAPE expression] } |{ unary expression } |(expression) |column |pub.column | literal |parameter |{ function ( expression | * ) } |{ expression { ISNULL | NOTNULL } } |{ expression [NOT] BETWEEN expression AND expression } |{ expression [NOT] IN ( values | select ) } |{ [EXISTS] ( select ) } |{ CASE [expression] { WHEN expression THEN expression } [...] [ELSE expression] END } |{ CAST ( expression AS type ) }

binary

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

unary

- | + | ! | ~ | NOT