import  org.hibernate.Criteria;
 import  org.hibernate.HibernateException;
 import  org.hibernate.engine.TypedValue;

 public   class  EscapedLikeExpression  implements  Criterion {

         private   final  String propertyName;
         private   final  Object value;
         private   final   char  escape;

         public  EscapedLikeExpression(String propertyName, Object value,  char  escape) {
                 this .propertyName = propertyName;
                 this .value = value;
                 this .escape = escape;
        }

         public  String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery)
         throws  HibernateException {
                String[] columns = criteriaQuery.getColumnsUsingProjection(criteria, propertyName);
                 if  (columns.length!= 1 )
                 throw   new  HibernateException("escaped like may only be used with single-column properties");
                 return  columns[ 0 ] + " like ? escape '"+escape+"' ";
        }

         public  TypedValue[] getTypedValues(Criteria criteria, CriteriaQuery criteriaQuery)
         throws  HibernateException {
                 return   new  TypedValue[]
                { criteriaQuery.getTypedValue( criteria, propertyName, value.toString().toLowerCase() ) };
        }

         public  String toString() {
                 return  propertyName + " like " + value + " escape '"+escape+"'";
        }

}

createCriteria(Cat. class )
.add(  new  EscapedLikeExpression("name", "Fritz%", '$') )