Hi, i have such a problem in my query.

i woudl like to query

"select * from student where name like '%er%' "

and in my HQL i put

findByNamedParam("FROM Student s WHERE s. name LIKE %:name%", "name", name)

and it causes error because program considers "name%" as the param not "name". How can i make sure that "name" is the named param, and the second "%" char is a wildcard character?

thank you!

oops sry! just realised that simply adding the "%" in the param rather than in the query string will get around with this! thnx