title: Getting incorrect sytax error with SQL Server
body: <p>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. </p>
  
  <pre><code>Select *
  From dbo.Case
  Where dbo.Case.CountyName='Milwaukee'
  </code></pre>
  
  <p>I keep getting this error: </p>
  
  <p>Msg 156, Level 15, State 1, Line 2
  Incorrect syntax near the keyword 'Case'.</p>
  
  <p>I've also tried taking off the "dbo" and it still does not work. </p>
  
  <p>What am I doing wrong? (Using SQL Server 2008)</p>