That won't help, because the incorrect entries will have Renewal/1 and
you change them to 0. Then the below doesn't affect any of them.
> > > > 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
> > number
> > want to be billed. Yes, there are always the exceptions, I was just
> > trying
> > to be generic.
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list, including removal,please see http://www.iea-software.com/maillist.html