Convert this SQL to EJB QL
kaliappan durairaj
Greenhorn
Posts: 9
posted 7 years ago
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 '%'
select * from table1 where primarycolumn like '123%' and nvl(column2, '###') like '%'
|