RE: [Emerald] What version of Emerald should we be using?

Ronnie D. Franklin ( )
Tue, 2 Mar 1999 01:35:51 -0600

But... if you have changed a "Credit Card" to a "Renewal" without first
changing Autobill to "0" won't this then reverse ones that you don't want to

The reason I bring this up is that over the past 2 years I am sure that some
MBRS that are set for Renewal still have Autobill = 1 ...

> This should do it:
> Update MasterAccounts
> Set PayMethod = "Credit Card"
> Where CreditCardAutoBill = 1
> AND Datalength(CreditCardNumber) >= 13

For more information about this list, including removal,
please see