Raymond,

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

cases?
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
recommended.

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


Luiz