SAND CDBMS SQL Reference Guide
SAND CDBMS SQL Database Objects and Language Elements

 

Previous Topic:
Nulls
Chapter Index
Next Topic:
Boolean Expressions (Search Conditions)

 

Other SAND CDBMS SQL Language Elements


Value Expressions

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.