Subject about nocase collation
Author donoteatcarrot
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