hello all,

I am new to both Interbase and IB Objects and I have a small problem
regarding some properties of TIB_Query.

I want to make two fields of a table case-insensitive for search but
not for display. I have seen a page in the properties where I can mark
a "CASE INSENSITIVE" check box and where I have to supply something in
the "UPPER-CASE EQUIVALENT" edit line. The problem is: What have I to
supply in this edit line ?

I have tried with UPPER(NAME) where "NAME" is the name of the field
that has to be case insensitive. It seems to work with the search
panel that I have associated to the form, but when I cancel the search
mode I receive an Sql error:

Token unknown:

UPPER

Can someone clarify the mechanism of case insensitivity ?

Thanks a lot
Salvatore Besso