Hibernate Criteria concatenate columns

bkraut · **Joined:** Sat Jun 09, 2007 12:29 pm **Posts:** 19

Is it possible to do something like this with Hibernate criteria?

select (a.name + ' ' + a.surname) as longname from persons a

guilherme-mussi · **Joined:** Wed Feb 21, 2007 1:48 pm **Posts:** 8

In case someone else is still searching for this, I posted a solution on my blog, which involved creating a new Criterion:
http://whaticode.com/2013/02/01/hibernate-criteria-concatenate-fields-in-like-and-ilike-operators/

I hope it helps you.