title: SQL Server "Incorrect syntax near" WHERE statement
body: <p>I've researched and researched... yet to find a solution. I've read people having similar trouble because of the encoding, but I've tried retyping the query and even used convert to UTF-8 inside Notepad++. Any ideas?</p>
  
  <p>Error:</p>
  
  <blockquote>
    <p>Incorrect syntax near 'NEW'.</p>
  </blockquote>
  
  <p>Query:</p>
  
  <pre><code>delete from [orgDefaults] 
  where ([orgcode] = N'NEW') 
    and ([ctlName] = N'AllowReportables')
  </code></pre>
  
  <p>This is being executed inside a VB.NET program I've created using this OLEDB driver:</p>
  
  <pre class="lang-vb prettyprint-override"><code>Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &amp; updates_mdb &amp; ";Jet OLEDB:Database Password=" &amp; Settings.Password &amp; ";")
  </code></pre>