Lee,

Actually by default Interbase is case INSENSITIVE. It's only if you use
DIALECT 3 in conjunction with quoted-identifiers, that references will
become case sensitive.

In the case of:

create table his(...);
create table HIS(...);
CREATE TABLE HIS(...);

The resulting table can be referenced as:

select * from his
select * from His
select * from HIs
select * from HIS


However, if you:

create table "his"(...);

then you can ONLY reference the table as:

select * from "his"

Bottom line: Unless you are looking for trouble -- NEVER use
quoted-identifiers


Sean