Hi,

I have a requirement where I need to use 'concat' and 'group_concat' functions in HQL's SELECT clause but as I use them in HQL I get following errors
a) "Undefine alias group_concat"
b) "Undefined alias concat"

The query I am using is:

SELECT group_concat( concat(E.firstName, ':', a.lastName) )
FROM Employee E
Group By E.department


Are "concat" and "group_concat" functions available in HQL ?

Can we use these functions in HQL's SELECT clause ?