title: Can we concatenate two properties in Hibernate HQL query?
body: <p>Lets say I have one table with two columns <code>firstname</code> and <code>lastname</code> with String datatype. Normally I write my hql query like </p>
  
  <pre><code>"select firstname,lastname from contact"
  </code></pre>
  
  <p>Can I write a hql query which concatenates both property ? </p>
  
  <p>Maybe something like <code>"select firstname+lastname as fullname from Contact"</code></p>