Jason,

Thanks. That's how it works for Oracle, too. However, I don't follow the
need for the NOCASE ColumnAttribute. Won't I be searching on the uppercase
index? Forgive my ignorance here.

Sounds like I'm going to have to purchase the documentation after all, huh?
;0)

Bob

-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Wednesday, October 17, 2001 6:32 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Case insensitive index


No, you have to maintain an uppercase equivalent column and put an index on
it.
Then, there is a NOCASE ColumnAttribute setting which will tell IBO to
substitute appropriately to accomplish case insensitive searching, etc.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Bob Jones" <bjones@...>
To: "IBObjects@yahoogroups. com" <IBObjects@yahoogroups.com>
Sent: Wednesday, October 17, 2001 3:06 PM
Subject: [IBO] Case insensitive index


> 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?
>
> Thanks.
> Bob






Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/