You can use coalesce to achieve the same. Maybe thats the standard
answer?
On Fri 03 Feb 2012 09:40:37 AM CST, Steve Ebersole wrote:
> HQL and JPQL define support for case expressions (both simple and
> searched), as well as the 2 "abbreviated" SQL CASE forms nullif and
> coalesce.
>
> Howeve
HQL and JPQL define support for case expressions (both simple and
searched), as well as the 2 "abbreviated" SQL CASE forms nullif and
coalesce.
However, we do not currently have a standard form for NVL/ISNULL. Part
of the problem is that SQL does not define such an abbreviated form
either. A
