title: Simple like-query does not work in MS-Access
body: <p>I have a simple <code>Ms-Access</code> database with one table named <code>Student</code> and it has two columns <code>ID</code> and <code>Name</code>.</p>
  
  <p>When I the database in Access and enter the query</p>
  
  <pre><code>select * from Student where Name like 'J%'
  </code></pre>
  
  <p>in its SQL view, it gives an empty resultset.</p>
  
  <p>But the table has a <code>Name</code> called <code>John</code>.</p>
  
  <p>I tried with other databases and tables also with <code>like-queries</code>, but none works. </p>
  
  <p>Can anyone please tell if there is any special reason for this???</p>
  
  <p>Thank you</p>
  
  <p><strong>Edit:</strong></p>
  
  <p>The same query works with c sharp code</p>