--- In IBObjects@yahoogroups.com, Svein Erling Tysvaer
<svein.erling.tysvaer@...> wrote:

>
> Hi Antti!
>
> I think there are two different ways to get case insensitive

sorting,

> one is to use a case insensitive character set (or maybe it is
> collation?), the other is to add another column that should

contain the

> uppercase equivalent of your column, populate this column through
> insert/update triggers and then specify this field as the

uppercase

> equivalent of your mixed case field and then IBO does the rest
> (unfortunately, I don't remember the name of the property, but it

is one

> simple property relating to the field in your TIB_Query).
>
> HTH,
> Set
>
> Antti Kurenniemi wrote:
> > Hi all,
> >
> > I'm (once again) probably missing something quite obvious, but

how can I

> > make IBO grids sort case-insensitive? It seems that the default

sort

> > differentiates upper- and lowercase characters which, while

technicaly

> > accurate, is not what I want. It also makes the searches

(including Locate)

> > work wrong. For example, a column with the following values:
> >
> > Kalavale
> > KOS - Kouhian Outo Seurue
> > Kopiotoimi Tampereella
> >
> > will never find the "Kopiotoimi" value because it stops

on "KOS", and this

> > is a bit bonkers (for the users). Any help appreciated.
> >
> >
> > TIA,
> > Antti Kurenniemi
>

Adding ORDER BY UPPER(<fieldname>) to the TIB_QUERY works fine for
me when used with a grid. Is there some reason you can't do this?
(Don't know whether this'd work with a search, but I'd bet there's a
way.)

Michael D. Spence
Mockingbird Data Systems, Inc.