title: SQL query in VB - Missing operand
body: <p>Just learning a bit of VB and want to search a very simple SQL query as follows:</p>
  
  <pre><code>Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
      firstOrd = txtFirstOrd.Text
      Me.OrdersBindingSource.Filter = "select * from orders WHERE firstDate =" &amp; firstOrd
  End Sub
  </code></pre>
  
  <p>Ive just got this executing on a simple button and keep getting this:</p>
  
  <pre><code>Syntax error: Missing operand after 'orders' operator.
  </code></pre>
  
  <p>Im pretty sure its a <strong>quote problem</strong> but cant work it out! Any help would be great!</p>