Hibernate: wildcard matching using Criteria

[Choon-Chern Lim]

I have a DB int column, "myNumber". How do I do wildcard matching using Criteria? Basically, 11 should return 112, 211, etc.

I tried the below, but didn't work... and I assume I had to convert the int column to String first, but wasn't sure how to.

    
criteria.add(Expression.like("myNumber", "%" + String.valueOf(longObject) + "%"));

Thank you.

[Mark Spritzler]

Don't need to do that

"%" + longObject + "%" should work.

Mark