Re: IDS 9.2: ORDER BY UPPER(varchar)

Posted in 2000

Edward Rosenthal — Fri, 23 Jun 2000 16:21:03 GMT — source: Informix-list mailing list archive (1991-1998)

or you could try a cluster index on foo, and not have to worry about the order by... Thomas Parsli wrote: > Is it possible to sort by a function in IDS 9.2? > (and use a index;) > > SELECT foo, bar, baz > FROM urk > ORDER BY UPPER(foo)> > I've RTFM'd, but obviously not enough... > > Thomas