Re: IDS 9.2: ORDER BY UPPER(varchar)

Cluster indexes will create 'physical CLOSE to logical, but they don't guarantee it.' So an order by would still be needed. And, as Thomas pointed out, but failed to state, the order by field has to be in the select list..... "Edward Rosenthal" <edrosenthal@home.com> wrote in message news:39531EE8.E34E5F7@home.com... > 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 >