0 Replies Latest reply on Feb 28, 2003 2:22 AM by Claude Glauser

    Question about LIKE and LOCATE statement.

    Claude Glauser Newbie

      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