Yes, that will work since SPUT works from the left. ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Thursday, May 28, 2009 4:28 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: FUNCTION TO USE
Dennis, Thanks. I believe this will work since the text names are either eight or nine digits long and the digit I want to change will always be the same position from the left. Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Thursday, May 28, 2009 4:27 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: FUNCTION TO USE 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
