how to create below query in HQL

LOKANATHA · **Joined:** Mon Sep 08, 2008 2:37 am **Posts:** 6

Hi,

i want to concatinate and get data from DB using hql

i want to get the relavent query for the below sql query

Code:

select  e.*,(e.firstname||' '|| e.middlename || ' '|| e.lastname) as EMPNAME from employees e

any help is greatly appreciated

wolli · **Posted:** Mon Nov 24, 2008 4:14 am

Have you tried:

select e, (e.FirstName ||' '|| e.MiddleName || ' '|| e.LastName) from employees e

You then should get an array with to elements {instance of e, concatenated name}.

But I suggest one of these approaches instead:

1) you use a "calculated" property in the mapping: formula="firstname || middlename || lastname"

2) you define a property on your employee class that does that in the getter.