Jim, A basic question. Is the data stored as a TEXT value or as one of the numeric formats such as INTEGER? If it is stored as text then UPDATE tablename SET colnname = (SPUT(colname,'x',4)) WHERE ... in above 'x' is replacement value.
You might also look at SMOVE function. If value is a numeric data type there is no one step way to do this. You need to convert the numeric value to a TEXT value, perhaps using FORMAT or CTXT. Then replace using SPUT or SMOVE as above. Convert back to a numeric value. Then update record. Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 ________________________________ From: Jim Belisle <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thursday, May 28, 2009 4:10:58 PM 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
