title: SQL Query "Syntax error near field"
body: <p>I am using a middleware system to connect to a Database system. We are using a lookup functionality which in turn creates an SQL Query based on the conditions we have provided in it.</p>
  
  <h2>SQL QUERY CREATED:</h2>
  
  <pre><code>SELECT "FunctionCode", "AUM", "Numerator", "Denominator", "EANUPC", "Length", "Width", "Height", "CategoryofEAN" FROM "tblIdocAlternateUOMs" WHERE MaterialNumber='09792021'
  </code></pre>
  
  <p>Error:</p>
  
  <blockquote>
    <p>'Error processing request in sax parser: Error when executing statement for table/stored proc. 'table' (structure 'statement'): com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'FunctionCode'.'.</p>
  </blockquote>
  
  <p>I have executed the above query in database system and it is working fine without the errors but I am seeing the error in my system when I am trying to retrieve the data from DB.</p>
  
  <p>DB System : Microsoft SQL SERVER</p>
  
  <p>Could you please let me know why are these kind of errors usually appear?</p>