Subject Re: [firebird-support] Quoted identifier
Author Kjell Rilbe
mona yazbeck wrote:

> I just can't
> write my field name all in upper case if it contains 2 or 3 words! How do
> you all do!?!?
>
> NAMEDEBTOR, DATEFIRSTCHECK, NOFILESURINTENDANT it's ugly...

If the identifiers have been defined like above when you created the
table, you can refer to them with any case you like as long as you don't
use quotes:

select NameDebtor, DateFirstCheck, NoFileSurIntendant

This works because the identifiers have been defined in all uppercase
and using plain 7-bit ascii characters only.

Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64