Hi,
I want to create a named query, which will return all the names which starts with "ABC", similar to the query below:
select * from customer where name like 'ABC%'
or, if i the
string 'ABC' is stored in a variable, than above query becomes:
select * from customer where name like name+'%'
I write a named query like this:
select c from customer c where name like :name
its working, but its not waht i want, when i changed the above named query to below:
select c from customer c where name like :name%
Above query gives exception. How to do such thing?
