Hi sl,

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

Then you only have a very limited number of options:

a) If you have some freedom over the table structure,
you cna store the actual string in one column and populate
another column (which will be queried by the email server)
automatically with UPPER of the original strings (using triggers).

b) You'll have to define the column in question with a case
insensitive collation. For FB1, you can use Dave's ibCollate
at http://www.brookstonesystems.com/
For FB1.5 its either waiting for Dave, do-it-yourself or use
my hackish LOADABLE collation in pjcolkit3:
http://www.jodelpeter.de/i18n/fbarch/index.htm

Regards,
Peter Jacobi