Hello,

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