title: "LIKE" operator works in MS Access, but not ADO
body: <p>I'm trying to filter records using "Like" with asterisks, it works when using Access 2010 returning many records.  I'm stumped why it returns nothing when used with ADO.  The code includes multiple tables and columns so to troubleshoot I made a simple query.  Here's the code:</p>
  
  <pre><code>strsql = "SELECT tproducts.Prod_Name FROM tproducts " _
  &amp; " WHERE tproducts.Prod_Name Like " &amp; Chr(34) &amp; "SO*" &amp; Chr(34)
  
  Set cn = New ADODB.Connection
  cn = connString
  cn.Open
  Set rs = New ADODB.Recordset
  rs.Open strsql, cn, adOpenStatic, adLockOptimistic
  
  ' test here
  iRecCount = rs.RecordCount
  rs.MoveFirst
  </code></pre>
  
  <p>Recordcount returns -1.</p>
  
  <p>When "Like" is replaced by "equals" it returns correct record so I'm sure it's able to connect to the database, for example:</p>
  
  <pre><code>strsql = "SELECT tproducts.Prod_Name FROM tproducts " _
  &amp; " WHERE tproducts.Prod_Name = " &amp; Chr(34) &amp; "SONY Vaio SVD13213CXB" &amp; Chr(34)
  </code></pre>
  
  <p>Is there a special way to use the Like operator in ADO?</p>
  
  <p>What other ways can I filter to give results same as using "Like"?  For example, to find all "<em>SVD</em>" products?</p>