How to handle table field names with a space or - 1

[rykk]

for example

select Field One from table (obvious problem)

select 'Field One' from table (but rejects this)

select Field-Two from table (rejects)

 

[danielhozac]

Perhaps try backticks: `Column One`.

//Daniel