--- In firebird-support@yahoogroups.com, "submitlord"
<submitlord@y...> wrote:

> Is there a command to make all string comparisions case-insinsitive?
>
> I can't use the function: UPPER()
>
> because the sql statement is hard coded in a third party email server.
>
> Thank you,
> -sl

Does the program update the table? If not, you could rename the table,
then create a view with the original table's name which does an
UPPER() on the column in question.

(I'm not that experienced in Firebird, to say if that view still could
be updated...)

Thomas