<< Click to Display Table of Contents >> Navigation:  Local SQL > Overview > Conventions > Column names

ANSI-standard SQL confines each column name to a single word comprised of alphanumeric characters and the underscore symbol, "_". Local SQL, however, is enhanced to support the Paradox and dBASE feature of non-alpha characters and spaces embedded in column names. Local SQL supports Paradox multi-word column names and column names that duplicate SQL keywords as long as those column names are

•Enclosed in single or double quotation marks

•Prefaced with an SQL table name or table correlation name

For example, the following column name consists of two words:

SELECT E."Emp Id"

FROM Employee E

In the next example, the column name is the same as the SQL keyword DATE:

SELECT DateLog."Date"

FROM DateLog