Hi can anyone help me out in converting the following SQL query to EJB QL, the following nvl fuction is not valid for EJB QL and i am searching for an equivalent function that work in EJB QL.
select * from table1 where primarycolumn like '123%' and nvl(column2, '###') like '%'
Something must be done about this. Let's start by reading this tiny ad:
