Hi Helen,

I have done this and all works well.
But one thing I have noted is that if I merely set the Case
Insensitve flag on the NAME field, it also works, without needing to
create the proxy field (UPNAME), triggers, etc

Can you please explain why it is beneficial to have the proxy field,
even though I can merely set the case insensitive flag and all seems
to work?

I gather there is a valid reason, I just can't see them.

Rgds,
-Ryan

>
> Yes, that's exactly right.
> In the ColumnAttributes *for the open-case column* set the CASE

INSENSITIVE

> attribute to true AND name the proxy column in the field alongside
> it. That's all you have to do to get the high-performance case-

insensitive

> search on the open-case column.
>
> The other parts of implementing this are, of course, to create the

proxy

> column, to write the two triggers for populating it and to index

it.

>
> Helen