Hello All:

We have an access database with text fields in multiple columns that needs to 
be converted to a specified value.  (Ex)  the string 000015825 needs to be 
changed to 00001582E.  We need to replace the right character with the 
following conversion values.

0 = }
1 = A
2 = B
3 = C
4 = D
5 = E  etc

Considering we have multiple columns in the database that need converting, 
what would be the best way to do this.

Thanks,

Jeff Parker

-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com

-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org

Reply via email to