0 Replies Latest reply on Mar 2, 2003 7:45 AM by Ansh

    concatenation operator in ejb-ql

    Ansh Newbie

      Hello everyone,

      I am using oracle and ejb components.

      I have two records in a table with name like 'abc xyz' and 'abc'.

      i have written a finder method 'findByName(String name)'.

      What i want is that, this method should return all those records in which the argument is found.

      eg if i pass execute findByName("ab") method, i want both the records to be returned.

      the sql query for it works absolutely fine.
      select * from tablexyz where name like '%ab%'

      i want a similar ejb-ql.

      thanking in advance for the help.