title: Filemaker Sql Queries against columns with spaces in the name
body: <p>I have an ODBC DSN setup to hit a Filemaker database from my ASP.Net application.  I'm trying to form a valid query where the column name has spaces in it.  In T-SQL, you would enclose it in [].  But I fail to get it to work in this case.  Here's a valid query:</p>
  
  <p>select * from ua_inventory where location like '%a%'</p>
  
  <p>But this is not:</p>
  
  <p>select * from ua_inventory where [item place] like '%a%'</p>
  
  <p>I get the following error:
  [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL </p>
  
  <p>Does anyone have a clue how to form queries where the table and/or columns have spaces in the name?</p>
  
  <p>Thanks in advance</p>