Getting incorrect sytax error with SQL Server

Question

I have what I think should be a simple question but for the life of me cannot solve it myself. I'm just trying to do a simple search on a table.

Select *
From dbo.Case
Where dbo.Case.CountyName='Milwaukee'

I keep getting this error:

Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'Case'.

I've also tried taking off the "dbo" and it still does not work.

What am I doing wrong? (Using SQL Server 2008)

Answer 1

CASE is a reserved keyword. You will need to enclose it in [] to use as a an identifier such as a database, column, or table name:

Select *
From dbo.[Case]
Where dbo.[Case].CountyName='Milwaukee'