Everything worked great! Thanks again.
--Gary
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
> Sent: Monday, June 26, 2000 12:51 PM
> To: emerald@iea-software.com
> Subject: Re: [Emerald] ICVerify
>
>
> Beachlink Administrator wrote:
> >
> > Given that, could I do the following???:
> >
> > UPDATE MasterAccounts
> > SET CreditCardExpire = SUBSTRING(CreditCardExpire,3,2) +
> > SUBSTRING(CreditCardExpire,1,2)
> > WHERE CreditCardExpire LIKE '____'
> > GO
> >
> > The '____' is four underscores denoting a length of 4.
>
> Should work. I always do a select before doing an update to
> make sure its what I expect:
>
> > SELECT CreditCardExpire, NewCreditCardExpire =
> SUBSTRING(CreditCardExpire,3,2) +
> > SUBSTRING(CreditCardExpire,1,2)
> > FROM MasterAccounts
> > WHERE CreditCardExpire LIKE '____'
>
>
>
> --
>
> Dale E. Reed Jr. Emerald and RadiusNT/X
> __________________________________________
> IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart