agentsinaction wrote:

> My problem is that a column name is a keyword for Firebird.
>
> create table test (min varchar primary key);
>
> I found out that this works:
>
> create table test ("min" varchar primary key);
>
> Using "select * from test" seems to work correctly. But how can I
> select that column?
>
> select min from test;
> select "min" from test;
> select test.min from test;
> select "test.min" from test;

select test."min" from test

But personally I would go with a different name anyway.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services