The equivalent to the nvl command in HQL is the coalesce command. coalesce(a,b) will return a if a is not null, otherwise b.
So you would want something on the lines of:
from Table where col1 = coalesce(:par1, 'asdf')
The equivalent to the nvl command in HQL is the coalesce command. coalesce(a,b) will return a if a is not null, otherwise b.
So you would want something on the lines of:
from Table where col1 = coalesce(:par1, 'asdf')