Is there a way to store the case of the column names but then to get
them without case sensitive feature?

For example, I have the "EnterDate" column in a table.

If I do "select * from Customers" or I use a report designer, I would
like to see the column name as "EnterDate", not "ENTERDATE". (Firebird
store all column names in upper case if you do not provide "")


I know that I can use the "" in Firebird to keep the case, but then,
the column is case sensitive.

I would like to store the column name as EnterDate, but then I would
need to use EnterDate or ENTERDATE or ENTERDate in the Select or Where
clause.

Do you know a way to do it?

Thanks