ColumnName = Keyword??

[jiggyg]

Hello All!

First post here, and I'm hoping someone can help me with this...

I'm working on a db that has a column named 'Function' -- and I want to do a select on that row, but am running into problems because it is a keyword...

How can I properly execute this (Can't change column name...)?:

SELECT Function, count(*)
FROM Space
GROUP BY Function;

When I execute that, I'm getting an error:
Incorrect syntax near the keyword 'Function'.

Thanks in advance for your time and help!!
-jiggyg

 

[dmears1]

SELECT [Function], count(*)
FROM Space
GROUP BY [Function];

 

[jiggyg]

Super!!

Thanks for the clarification!

 

[ESquared]

or "Function" depending on your setting for QUOTED_IDENTIFIER

[COLOR=black #e0e0e0]For SQL and technical ideas, visit my blog, Squared Thoughts.

_{The best part about anything that has cheese is the cheese.}[/color]