title: how to write jpql query with like operator
body: <p>How to write below sql query in JPQL in java class</p>
  <pre class="lang-sql prettyprint-override"><code>select e.emp_id, e.emp_name
  from emp e 
  left outer join dept on e.dept_id = d.dept_id and upper(d.dept_name) like upper('%dev%') 
  </code></pre>
  <p>I have tried below it doesn't work for me. I need after like keyword how to write with two percentile and parameter name</p>
  <pre class="lang-java prettyprint-override"><code>@Query(value = &quot;select e.emp_id,e.emp_name from emp e left outer join dept on e.dept_id= d.dept_id and upper(d.dept_name)  like upper(%:deptName%), nativeQuery = true)
  List&lt;Employee&gt; searchAllEmployees(@Param(&quot;deptName&quot;)String deptName);
  </code></pre>