Hi everyone, I have a CMP entity bean which defines a finder method like this: Collection findByPartialUserName(String UserName). I have deployed this entity bean against an oracle database but I am having trouble specifying the query for this finder method. Ideally I want the SQL query to look something like this: "SELECT * FROM users WHERE username LIKE '%abc%', but I have no idea how to specify such a query within the deployment descriptor. For now I have simply entered "$UserName LIKE $1" into the query clause and I am manually adding the leading and trailing percent sign to the UserName parameter before calling this finder, but it seems like there should be a better way. Has anyone run into a similar problem and solved it? I've also tried "$UserName LIKE '%$1%'" and "$UserName LIKE %$1%" but the database complains that the statement is invalid. Thanks in advance for any suggestions. Andre V
