Hi,

I am trying to use coalesce expression(CoalesceExpression.java) in my HQL query. But I am finding difficulty in writing the exact code for it. Please somebody provide example to use coalesce function in where condition.

My Query is something like this:
select em from Employee em where em.firstName=coalesce(?,em.firstName);

please note that in coalsce function if my value is null then i want to pass column name as it is.

Waiting for reply.

thanks
partha.