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) +
> 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