Boolean Expressions (Search Conditions)
Other SAND CDBMS SQL Language Elements
A value expression is an SQL argument consisting of direct column references, or of arithmetic operations involving columns, functions, and character or numeric constants. The result of a value expression is a single numeric, character string, or date/time value (in contrast to a Boolean value expression, which returns a TRUE / FALSE / UNKNOWN value, or a table expression, which returns an entire table). Value expressions are used in a number of different contexts, such as in the projection list of a SELECT statement, as new column values in INSERT or UPDATE statements, and in the query expression of a CREATE VIEW statement.
For more syntax and usage information, refer to Value Expressions.