How to give rtrim to a column name in a hibernate criteria

kuzhali · **Posted:** Wed May 23, 2007 6:10 am

Hi,

I want to write a Query using hibernte criteria as follows:

select * from <tableName> where rtrim(ColumnName) like '123';

But in criteria i don't know how to give ltrim(rtrim(columnName).

Can anyone help in this?

As the column is of type Char it is not working on DB side if i give simply 'like'. I need to give "rtrim(columnName) like' to retrieve the values.

amila733 · **Posted:** Wed May 23, 2007 10:05 am

Hi

Code:

List list=sess.createCriteria(DefaultValue.class).add( Restrictions.sqlRestriction("rtrim(field1) like ?", "Fie%", Hibernate.STRING) ).list();

Code:

List list=sess.createCriteria(DefaultValue.class).add( Restrictions.sqlRestriction("ltrim(rtrim(field1)) like ?", "Fie%", Hibernate.STRING) ).list();

Amila

(Don't forget to rate)

kuzhali · **Posted:** Thu May 24, 2007 4:54 am

Hi,

It is helpful, but i don't want to use sql restrictions here.

My criteria looks like:

List list=sess.createCriteria(DefaultValue.class).add( Restrictions.like("empNm", new String ("tst")).

So, i will not be able to use sql criteria along with this.

Is it possible to handle it with Restrictions itself?