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@...>
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/
>
>
>