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,

A better title for the question might be "how to query with attribute name that contains a space" — Merlyn Morgan-Graham, May 12 '11 at 04:16
This is a SQL question, not an ASP.Net question so I changed the tag and some wording — Joe Phillips, May 12 '11 at 04:18

score 10 · Answer 1 · answered May 12 '11 at 04:14

10

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

answered May 12 '11 at 04:14

Tushar

1,220
1
8
17

score 2 · Answer 2 · answered May 12 '11 at 04:14

2

Try throwing square brackets around it:

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

answered May 12 '11 at 04:14

Abe Miessler

79,479
96
291
470

score 2 · Answer 3 · answered May 12 '11 at 21:22

2

The Standard SQL delimiter (and supported by SQL Server) is the double quote e.g.

SELECT * 
  FROM States 
 WHERE "State Name" = 'Michigan';

answered May 12 '11 at 21:22

onedaywhen

53,058
12
94
134

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

3 Answers3

Linked