> You don't imagine how ALL CAPS, small caps and Mixed Caps was discussed
> last days. :-)
>
> If you put the table name (or other identifier) enclosed on quotes, you
> SHOULD use it everywhere with the quotes

Unless you use all-caps :-) ... Then it's case insensitive again.

So, in general, if you want to avoid case problems, don't use quotes. But
Firebird isn't case preserving either.

If you want to use case, reserved words and make it case preserving,
use double quotes.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com