title: Using LIKE and '%'  in an ADO dataset filter
body: <p>I have a problem when trying to apply a filter to a ADO dataset in Delphi XE2 ...</p>
  
  <pre><code>Filter := ' [Name] like ''%john'' ';
  </code></pre>
  
  <p>It raises an exception:</p>
  
  <pre><code>Project Test.exe raised exception class EOleException with message 
  'Arguments are of the wrong type, are out of acceptable range, 
  or are in conflict with one another'. Process stopped. 
  </code></pre>
  
  <p>but when using:</p>
  
  <pre><code>Filter := ' [Name] like ''john%'' '
  </code></pre>
  
  <p>it works fine!</p>
  
  <p>why?</p>