Helen Borrie wrote:

>> Depending on how well you parse input, you might need to maintain an
>> indexed uppercase proxy column for the two columns and make search
>> conditions case-insensitive. The practice some people have of using
>> mixed case in their email addresses is another major reason not to use
>> them as keys. They are *highly* non-atomic.

Helen, what's your personal name convention for proxy columns like that?

_P_EMAIL?
_U_EMAIL?
EMAIL_UPPER?
UPPER_EMAIL?
_EMAIL_UPPER?

Just curious.

--
dave