Case insensitive search in hibernate without criteria

I want to do case insensitive search in hibernate Query. I can do it with Criteri开发者_Go百科a but it is not an option for me right now. The method which fire query takes a query string as input and it is used by other components. Is it possible to enable case insensitive for Hibernate session or prepare criteria object from hql query.

---

You can use the lower or upper functions mentioned here.

from User u where lower(u.name) = 'scott'