LIKE (and STARTING) ignores collation.
Unless you need to use index, try
upper(f1) LIKE upper(f2)


Ivan

----- Original Message -----
From: "donoteatcarrot" <donoteatcarrot@...>
To: <firebird-support@yahoogroups.com>
Sent: Sunday, September 04, 2005 10:30 AM
Subject: [firebird-support] about nocase collation


Hello, I have a problem with collation.

In "http://www.brookstonesystems.com/ibCollate3.html", at "NOCASE
drivers:",
it sais that "For all NOCASE drivers, if upper(f1) = upper(f2) then
f1 = f2."
and a example is given below.

I downloaded the "collate020607.zip" and tested
SELECT Field FROM T WHERE Field = eAf COLLATE EN_UK_NOCASE;
sucessfully.

but
SELECT Field FROM T WHERE Field like e%A%f COLLATE EN_UK_NOCASE;
dose not work.

If I want the nocase collation also work good with "like" statement,
how should I do ?
Any comments or opinions will be very welcomed.

Ryu