| Subject | Select column AS [column name] with space |
|---|---|
| Author | ramona.grissom |
| Post date | 2013-04-19T15:14:30Z |
How can we accomplish this in Firebird?
In MSSQL for example you can SELECT column AS [column name]. The "column name" can contain spaces and be named a reserved word because it's escaped with the square brackets.
But not sure about
SELECT CustomerName AS "Customer Name"
FROM Customers
Thank you in advance for your help.
In MSSQL for example you can SELECT column AS [column name]. The "column name" can contain spaces and be named a reserved word because it's escaped with the square brackets.
But not sure about
SELECT CustomerName AS "Customer Name"
FROM Customers
Thank you in advance for your help.