SQL expressions

Use expressions in WHERE, HAVING, and ORDER BY clauses of SELECT statements to form detailed and sophisticated database queries. Valid expression elements are:

• Field names

• Constants

• Exponential/scientific notation

• Numeric operators

• Character operators

• Date operators

• Relational operators

• Logical operators

• SQL functions