Increment an alpha field by "1"

[Peter Vidal <Peter_Vidal@xxxxxxxx>]

Hi list:

I have a field (7/A) that has a combination of letters and numbers.  How 
will the code look so I can go from, ie.:

Original value: MTAA010
Target value: MTZZ990

The first character (M) and the last one (0) will never change.  Just 
positions 2-6

All recommended strategies are welcome,

TIA! 


PETER VIDAL 
MAPICS IT TECHNICAL SUPPORT TEAM / SR SYSTEM ANALYST 
10540 Ridge Rd., Suite 203, New Port Richey, FL 34654-5111
Tel:727-849-9999, x2414 Fax:727-815-3120
WWW.PALL.COM 

"Use what talents you possess: the woods would be very silent if no birds 
sang there except those that sang best."
Henry Van Dyke

--------------------------------------------------------------------------------

Attention:

This communication may contain information that is confidential,
privileged and/or exempt from disclosure under applicable law.  
If you are not the intended recipient, please notify the sender 
immediately and delete the original, all attachments, and all 
copies of this communication.


--------------------------------------------------------------------------------