Informix rtrim/ltrim problem

[Anon]

Hi people,

I need your help. I have an application using these kind of SQL sentences:

select * from TABLE_NAME where rtrim(FIELD_NAME)='VALUE'

when the application is running on Oracle, Sybase or Microsoft SQL database engines, it works properly.
But when the application is running on Informix and you run this query the selection becomes sequential instead of an indexed search as it should be.

Is it an Informix bug? How can we solve it?

Thanks a lot