how to use sql functions inside criteria?

[shah rah]

I need to comapare name from database(can have mixed case) and the name user has entered.

I need to do something like

select name from table where lower(name)='apple'.

I am using criteria

criteria.add(Expression.like("name", inputName.toLowerCase(),MatchMode.Anywhere));

How to use the LOWER sqlSERVER function inside Criteria?

[Mark Spritzler]

I believe in Expression or maybe it is actually the Criteria object that has a ignoreCase() method, or the like.

Mark