Re: [Emerald] rebatch behind the scenes .... ?

Dale E. Reed Jr. ( (no email) )
Fri, 11 Jun 1999 10:00:23 -0700

Dan Tang wrote:
>
> >field. What about those that are constructed by Username@Domain? Many ISPs
>
> Use a script to update the email field, because that is the fuction which
> IEA wants you to use, IEA may have other use of the DOMAIN in the future. It
> is the best practice to use those fields.

If you don't mind me asking, who told you that? I'm not sure who "IEA"
is, but the EMail field should NOT be filled in by default. Its rather
trivial to do a CASE statement on the email field and bring in the
login/domain if its blank:

Select FullEMail = CASE
WHEN sa.EMail IS NOT NULL THEN sa.EMail
ELSE sa.Login + "@" + d.MailDomain
END