How can I reference a column with a space in the name?

Question

I'm trying to run a statement where I retrieve tuples from a database. However my attribute has a space which is "State Name".

Im calling the SQL statement as follows:

select * from States where State Name = 'Michigan';

I'm pretty sure there is something wrong with the attribute having a space. How can I fix this problem without changing the name of the attribute? How can I call a SQL statement with the attribute constraint having a space?

Thanks,

Answer 1

select * from States where [State Name] = 'Michigan';

Answer 2

Try throwing square brackets around it:

select * from States where [State Name] = 'Michigan';