Criteria c; String sql = "length(user_no) = 8"; Criterion sqlRestriction = Restrictions.sqlRestriction(sql); c.add(sqlRestriction);