Subject problem with column names starting with number character
Author Daniel
Hi,

I'm facing a problem creating a SQL to retrieve data from a table.

the table has two columns starting with number in the name the two columns are: 6mes, 12mes.

Then when I try to execute the folowwing SQL:
SELECT tb.6mes,tb.12mes from biz_table tb;

it gives me the following error:
GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 10
.6

How can I build this SQL, in order to get these data?
I'm using hibernate with jaybird JDBC driver. But even when I try to execute through a SQL executor problem it gives me same problem.

Setup:
Firebird 2.1 (x64)
Jaybird 2.1.6
Windows S.O.

Do you know how to deal with it?

Thanks,