TurboSQL Guide Column Names |
Previous Top Next |
Like the ANSI-standard TurboSQL confines each column name to a single word comprised of alphanumeric characters and the underscore symbol "_". To distinguish similar column names from different tables preface the table name.
SELECT Employee_Id
FROM Employee
or
SELECT Employee.Employee_Id
FROM Employee
In addition, TurboSQL can use the German umlauts for column names and table names:
SELECT Kürzung
FROM Beiträge
For using column names that contain spaces or other special characters and for distinguishing column names from e.g. function names, you can enclose the column name in brackets or double quotes:
SELECT "Employee Id", [Employee Id]
FROM [Update]