""Bob Jones"" <bjones@...> wrote in message
news:KLEIKLJAPOGNMLFLOKMCGEDLCCAA.bjones@......

> How do I create an index that is not case sensitive? Is there a property
> that I set to ignore case on the index, or does Interbase support

functional

> indexes?

You will have to rely on
www.brookstonesystems.com
for installable, case-insensitive collations if you want the solution in the
engine and not in the client application.

Otherwise, IBO has you covered with a couple of settings and some trivial
triggers. If you need correct uppercasing in non-ASCII cases, use the
charset that suits your needs.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing