for safety, preserve the existing column and update another column with this
UPDATE tablename set targetcol = (SGET(sourcecol, 3,1) + '-' + SGET(sourcecol, 3,4) + '-' + SGET(sourcecol, 4,7)) -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey Sent: Friday, September 19, 2014 2:59 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Changing formats in a column Just purchased a new mailing list. Phone numbers are text ie: 1234567890 Want to re-format them to read 123-456-7890 Cannot figure how to change them in mass, rather than running an eep using a routine of SGET's on a very large table. Any ideas? Dick Fey Carpet Broker Inc.
