Expressions are formed by combining data, often in the form of column references, with operators or functions.
expression: case-expression | constant | [correlation-name.]column-name | - expression | expression operator expression | ( expression ) | function-name ( expression, ... ) | if-expression | special value | input-parameter
case-expression: CASE expression WHEN expression THEN expression,... [ ELSE expression ] END
alternative form of case-expression: CASE WHEN search-condition THEN expression,... [ ELSE expression ] END
constant: integer | number | string | host-variable
special-value: CURRENT { DATE | TIME | TIMESTAMP } | NULL | SQLCODE | SQLSTATE
if-expression: IF condition THEN expression [ ELSE expression ] ENDIF
input-parameter:
{ ? | :name [ : indicator-name ] }
operator: { + | - | * | / | || | % }
Constants in expressions
Column names in expressions
IF expressions
CASE expressions
Aggregate expressions
Subqueries in expressions
Input parameters
Search conditions in UltraLite
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |