Re: [Emerald] ICVerify

Dale E. Reed Jr. ( (no email) )
Mon, 26 Jun 2000 09:51:13 -0700

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