Re: It's a dummy question...

Alexey Poukhovsky wrote: > > Hello, All! > Can you tell me, has Informix SQL "Upper" function. Or any other method to > make "order by" case unsensitive? > > In Oracle I made it like select * from tab order by UPPER(field). No, there is no general way. You can write a stored procedure for this special case (one for each length) see the FAQ. (one for char(16), one for char(8) ...) But note, that this was never a good query. In Oracle this will cause a sequential scan and an in flight sort.