At 05:37 PM 4/10/2004 -0700, you wrote:

>Hi, Helen
>
> Thanks for the quick answer. I'll do it. Storing
>proxy fields would be the solution, but it would cause
>the database become more bigger (think about if the
>client table is at least 1 million records, and we may
>need multiple proxy fields like First name, Last name,
>... etc), so is it possible that it can be
>improved/solved at the database engine level?

Eventually, perhaps, by one or both of

-- addition of case-insensitive collations to character sets - an amazingly
costly overhead in most cases
-- support for expression indexes - the best bet IMO.

Both are on the table as future enhancements.

./heLen