How many columns are there and is the conversion factor known? Also, when and how often does this conversion need to be done?
You might look at the ReplaceList function. It might be able to do what you're wanting. Hatton > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of [EMAIL PROTECTED] > Sent: Thursday, December 06, 2001 12:08 AM > To: [EMAIL PROTECTED] > Subject: Manipulating string data > > > 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 > ------------------------------------------------------------------------- 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
