the following hql query with searchText parameter seraching for match case only.

String HQL = from MyTable n where n.title like :searchText

session.createQuery(HQL).setParameter("searchText","%"+searchFilter.getSearchText()+"%");


can some body help as how to write a query that seraches for both uppercase & lower case match

String HQL = from MyTable n where lower(n.title) like :searchText

session.createQuery(HQL).setParameter("searchText","%"+searchFilter.getSearchText().toLowerCase()+"%");

it gets all upper case words from databse when input given in lower , but
it won't get lower case words from databse when input given in upper ,

that's why I added toLowerCase() to your search text

Thanks it solved the problem ......