title: SQL DELETE statement syntax
body: <p>Trying to execute a delete query and getting the following error </p>
  
  <blockquote>
    <p>Syntax error (missing operator) in query expression 'cname VALUES @cname'.</p>
  </blockquote>
  
  <p>code</p>
  
  <pre><code>Dim conn As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" &amp; My.Settings.strFileName)
  conn.Open()
  Dim cmdText = "DELETE FROM products WHERE cname VALUES @cname"
  Dim cmd As OleDbCommand = New OleDbCommand(cmdText, conn)
  With cmd.Parameters
    .Add(New OleDbParameter("@cname", DataGridView1.Item("cname", i).Value))
  End With
  Dim dt As New DataTable("products")
  cmd.ExecuteNonQuery()
  conn.Close()
  conn = Nothing
  </code></pre>