I read in the groups that the like statement won't work with parameters:
select distinct object(p) from PhoneList p where p.firstName like ?1 and p.lastName like ?2"
Many say (in this forum) that they solved the problem with the LOCATE statement. How can I get the same result as the above statement with the locate statement ? I know that there is a JBoss extension for this, but I would like to solve the above with the locate statement. Do you know resources with documented examples ? Thanks a lot in advance, Claude