title: HQL Query with like and or operators
body: <p>I'm using Hibernate, I want to get records based on like condition which contains or condition. It is something like this,  </p>
  
  <blockquote>
    <p>from Employee where empno in (select empno from Employee where empname like 'A%' or 'B%' or 'C%' )"  </p>
  </blockquote>
  
  <p>Is it correct? Suggest me robust query..  </p>