Ryan Nilsson-Harding wrote:

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

This would test each record; i.e. it doesn't use an index.

On a small table it won't be noticeable. With thousands of records in a multi-user
environment it will be noticeable. Searching for 2 records amongst 10,000,000 will require
a coffee-break.
--
Raymond Kennington
Programming Solutions
W2W Team B