SQL Statements for Flat-File Drivers : Select Statement : SQL Expressions

SQL Expressions
Expressions are used in the Where clauses, Having clauses, and Order By clauses of SQL Select statements.
Expressions enable you to use mathematical operations as well as character string and date manipulation operators to form complex database queries.
The most common expression is a simple field name. You can combine a field name with other expression elements.
Valid expression elements are as follows:
Constants
Exponential Notation
Numeric Operators
Character Operators
Date Operators
Relational Operators
Logical Operators
Operator Precedence
Functions

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.