At 08:41 PM 24/11/2003 +0700, you wrote:

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

Not _ANYTHING, for sure, since some Delphi components prepend _ to column
names for some internal functions. Since I always index such columns, I
generally name them XWhatever. This makes it easy for me to set the alt
column identifier in the IBO dataset editor as well (IBO has provision for
this to enable lightning-fast case-insensitive searches).

heLen