There doesn't seem to be a getNewCriterion(String column, SqlEnum comparison)
What do I do if I need something like select ... where a < 1 and a > 0 and (b is null or (b not like 'abc%' and b not like 'xyz%') ? I was planning on Criteria crit = new Criteria(); crit.add(a, 1, Criteria.LESS_THAN); crit.add(a, 0, Criteria.GREATER_THAN); Criterion c1 = crit.getNewCriterion(b, Criteria.ISNULL); // no such method Criterion c2 = crit.getNewCriterion(b, (Object) "abc%", Criteria.NOT_LIKE); Criterion c3 = crit.getNewCriterion(b, (Object) "xyz%", Criteria.NOT_LIKE); crit.and(c1.or(c2.and(c3))); This does not work with the ISNULL as part of the criterion. Is this a case where I have to resort to a CUSTOM expression of b, (Object) "b is null", Criteria.CUSTOM ? Thanks, Brendan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]