title: SQL LIKE operator with parameters and wildcards
body: <p>I have a query where I want to return all Clients that have a certain string in the name with wildcards on either side. So the input could be "Smith" and i want to return all things like "The John Smith Company" or "Smith and Bros". I want [Client] to be prompted so I set up the SQL like this:</p>
  
  <pre><code>PARAMETERS Client Text ( 255 );
  SELECT *
  WHERE (((tbl_IncomingChecks.Client) Like'%' + [Client] + '%') 
  ORDER BY tbl_IncomingChecks.Client;
  </code></pre>
  
  <p>The query is not returning any results. Please help</p>