Is this a text string with all records having the same number of digits? If so you can use SPUT to drop a new value in a certain position in each row
Update tablename set colname = (SPUT(colname,'5',3)) where clause This would put the charater '5' in the third position in each target string Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Thursday, May 28, 2009 4:11 PM To: RBASE-L Mailing List Subject: [RBASE-L] - FUNCTION TO USE What function do I use to change a specific digit in a series of digits. I want to change just the fourth digit in a group of rows. Jim
