title: trying to get a query to use the LIKE function with a variable in JSP
body: <p>I have a query that is being used to pull usernames and info about the user. In Access I had the LIKE function so that the user didn't have to type in a specific name. I am now transferring it over to JSP. Here is the line in the query that I am having troubles with in JSP:</p>
  
  <pre><code>WHERE ObjectName Like '" + "%"+ VariableName + "%" +"';
  </code></pre>
  
  <p>The query runs fine but does not show any information even if I put in the entire name. If I change it to:</p>
  
  <pre><code>WHERE ObjectName = '" + VariableName +"';
  </code></pre>
  
  <p>it works, but I would like to give the user a chance to have to ability to put in partial names in case they do not know how to spell the name or typ eit incorrectly. Any help would be apprecited.</p>
  
  <p>Thanks </p>