I have converted all MYY to MMYY by using:
SET CreditCardExpire = '0' + CreditCardExpire
WHERE CreditCardExpire LIKE '___'
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???:
SET CreditCardExpire = SUBSTRING(CreditCardExpire,3,2) +
WHERE CreditCardExpire LIKE '____'
The '____' is four underscores denoting a length of 4.
> 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: