Re: quotes problem in query syntax

[Bryan Pendleton]

create table mt ( mf varchar(5) )
select x."mf" from mt x

If you enclose identifiers (table/column names, etc.) in
double quotes, then the case must match exactly.

So this would work:

  create table mt ( mf varchar(5) )
  select x."MF" from mt x

or this:

  create table mt ( "mf" varchar(5) )
  select x."mf" from mt x

If you do not enclose the identifier in double quotes,
Derby converts it internally to upper case.

thanks,

bryan