Expressions in UltraLite

Expressions are formed by combining data, often in the form of column references, with operators or functions.

Syntax
expression:
 case-expression
| constant
| [correlation-name.]column-name
| - expression
| expression operator expression
| ( expression )
| function-name ( expression, ... )
| if-expression
| special value
| input-parameter
Parameters
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:
{  +  |  -  |  *  |  /  |  ||  |  % }
See also

Constants in expressions
Column names in expressions
IF expressions
CASE expressions
Aggregate expressions
Subqueries in expressions
Input parameters
Search conditions in UltraLite