trim function for Hibernate criteria

[Mohit Sinha]

Hi there,

I need to apply a trim function on a database column which is part of the Criteria query not HQL. I did not find a way with the available documentation nor on Hibernate related forums.
The data in the database can contain some trailing spaces. need to get rid of it when using a expression.eq via a criteria clause.

Let me know your thoughts

Thanks,