spaces in field names

[Mariusz Gadek]

Hi,

Some DB user have a nice idea to use spaces or other characters in field names like: Field 1 or Field-1 a.s.o.
Does ODBC driver for MySQL support a way to deal with such bad things?
I mean querys like that:
SELECT myTable."Field 1", myTable."Field-1" FROM myTable?
It works on all other databases I have tested but there is a problem when using MySQL via MyODBC. Any ideas why it doesn't work?

thx

Mariusz