title: How to use TClientDataSet to locate containing string
body: <p>I'm using Delphi 2007.</p>
  
  <p>I know i can use the .locate method of a TClientDataSet to locate a record, like this:</p>
  
  <p>myClient.locate('name','John',[loPartialKey,loCaseInsensitive]);</p>
  
  <p>But let's say i want to locate any record with 'John' containing on its name, something as </p>
  
  <blockquote>
    <p>name like '%John%'</p>
  </blockquote>
  
  <p>would do in a regular SQL expression.</p>
  
  <p>Is this possible using the .locate method ?</p>
  
  <p>It seems the [loPartialKey] works as starting with instead of containing.</p>