> > > This should do it:
> > >
> > > Update MasterAccounts
> > > Set PayMethod = "Credit Card"
> > > Where CreditCardAutoBill = 1
> > > AND Datalength(CreditCardNumber) >= 13
> This assumes that those with CCAutoBill set to 1 and a credit card
> want to be billed. Yes, there are always the exceptions, I was just
> to be generic.
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html