Q:  How can I reference a field name with a space in a query?

A:

select * from MyTable
where MyTable."field with spaces" = 123