Column Names in Expressions

A column name is an identifier preceded by an optional correlation name. A correlation name is usually a table name.

If a column name has characters other than letters, digits, and underscores, the name must be surrounded by quotation marks (“”). For example, the following are valid column names:

Employees.Surname
City
"StartDate"
Related concepts
Constants in Expressions
Subqueries in Expressions
SQL Operators
Compatibility of Expressions and Constants
Subqueries in Search Conditions
Related reference
IF Expressions
CASE Expressions
Reserved Words
Identifiers