title: HQL query with LIKE having issues
body: <p>I am working on a search query using HQL and everything works find until I get to the LIKE clause. No matter what I do it does not seem to execute the LIKE clause properly. Here is my query.</p>
  
  <pre><code>String QUERY = "FROM Person as p WHERE p.createUser = : createUser 
       AND p.personId in (SELECT pn.personId FROM PersonName pn WHERE pn.personNameType = 'FIRST' AND pn.name LIKE '%:firstName%')";
  
  (List&lt;Person&gt;)session.createQuery(QUERY).setString("createUser", createUser).setString("firstName", firstName).list();
  </code></pre>