Re: Reserved names as column names

Robert Wehofer wrote:

> Hello there!
>
> How can I select a table having a reserved word as column name?
>
> Example:
> SELECT TABLE FROM TABLENAME; // does not work
> SELECT "TABLE" FROM TABLENAME; // does not work
>
> Regards,
> Robert

As Mark indicates use double quotes.
But keep in mind this will not work with report writers and many third-party tools. Best to rename those columns ASAP.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)