Re: referencing column names properly

On Sat, Feb 08, 2003 at 18:34:31 -0500,
"Sill-II, Stephen" <Stephen(dot)Sill-II(at)ost(dot)dot(dot)gov> wrote:
> I have a table called logs with several columns whose names have '-' in
> them, e.g. User-Name
>
> I'm having trouble referencing these columns with SELECT statements.
>
> What would the proper way to address these in a statement like this?
>
> SELECT User-Name, max(Date), max(Time) from logs;

You need to use double quotes around the column name. When you do that
case will become significant. If you didn't quote the column name on
the create table command, then the name would have been converted to
lower case.