Subject Re: [IBO] GSG041. YES CASE.
Author Luiz

> Can an IB_Query search be non-case-sensitive for a field that has both
Yes. It can.

> If so, wouldn't this be much slower than creating an uppercase field (in a
trigger) and
> placing an index on the uppercase field?
If you don't use collations case insensitive, what you suggested is the

> If one creates an uppercase field for indexed searching, how does one
display the
> mixed-case field for the user and search by the uppercase field?
In ColumnAttributes of the query, there is option to case insensitive and
upper-case column equivalent.