Brookstones' is at http://www.brookstonesystems.com/

it currently works on Windows only, though
Didier

--- In ib-support@yahoogroups.com, "Luiz" <cprmlao@i...> wrote:
> Your approach will becomes very slow if the clients table is big.
>
> You can use a new collation developed by from David BrookStone(I
don't have
> the link now, but you can search on net) or create a separate column
> populated for triggers to save uppercase values to your column.
>
> Luiz.
> ----- Original Message -----
> From: "Kumar" <manuelf001@h...>
> To: <ib-support@yahoogroups.com>
> Sent: Tuesday, January 14, 2003 8:02 PM
> Subject: [ib-support] Case Sensitivity on Indices
>
>
> > Aloha Again... Thanks so much for the advice given so far. I've
> downloaded more manuals than I've time to read, but am making a lot of
> progress on identifying the conversion (DBISAM -> FB) issues.
> >
> > In DBISAM, there is the ability to indicate that an index is not case
> sensitive. Thus, "Abc" would be right next to "ABC" rather than far
apart
> in the index, the thus (I believe) optimize a query on the field.
> >
> > I can't seem to find such an animal in FB. Would something this
work:?
> >
> > Select * from Clients where Upper(Clients.Name) like 'SMITH%'
> >
> > TIA,
> > -k-
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >