Expression Concepts

Expressions are values that are computed based on other database values. For example, you could create an expression to calculate the amount of a sale. The expression, named Sale_Amount, is calculated as:

QUANTITY * PRICE

Expressions are written in database-specific SQL. You can use expressions for many purposes, such as, performing math calculations, concatenating two columns, and retrieving the current date and time.