George Have you tried something like this
UPDATE tableName SET TextColumn = (SGET(TextColumn,45,2)) where ....... 45 shows the number of char in the field. So if your text column is 100 you want to use 100 or 99. Buddy ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of George H Baker Sent: Thursday, June 19, 2008 10:30 AM To: RBASE-L Mailing List Subject: [RBASE-L] - SGET use Does anyone have a snipet of code that can be used to set up SGET to delete the first character of data in a text field? I had this working as a pointer in 2.11 but progress marches on and there must be a simpler was of doing it.This is my first need in 7.6. Any idea would certainly be helpful and a time saver for me. George Baker
