I have converted all MYY to MMYY by using:
UPDATE MasterAccounts
SET CreditCardExpire = '0' + CreditCardExpire
WHERE CreditCardExpire LIKE '___'
GO
The '___' is three underscores denoting a length of 3. It worked, although
it may not have been the most resourceful way to do it.
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.
Again, thanks!
> Dale,
>
> Back in March, you said that a script to change
> MasterAccounts.CreditCardExpire from MMYY to YYMM would be
> simple. Could you
> please provide that script?
>
> We are using ICVerify, and I have grown tired of modifying the batch-out
> file every day.
>
> Currently, all of our CreditCardExpire entries are in MMYY
> format, although
> some are MYY (for example, 302 = March 2002) because the leading
> zeros were
> not entered.
>
> Thanks in advance...
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart