Hi Hibernate experts,

Please help me to implement the wm_concat function in HQL.


If my table has a column name with values

Institution_id name
1 Iowa University1
2 Iowa University2
3 Iowa University3
4 Iowa University4
5 Iowa University5

Then I want the value returned by my HQL query as

Iowa University1,Iowa University2,Iowa University3,Iowa University4,Iowa University5

I don't want to use native SQL or reading values and iterating and generate String value.

Thanks,
Hari