How about: UPDATE tablename SET columnname = ((SGET(columnname,3,1)) + '-' + (SGET(columnname,3,4)) + '-' + (SGET(columnname,4,7)))
? Sent using OWA for iPhone ________________________________________ From: [email protected] <[email protected]> on behalf of Dick Fey <[email protected]> Sent: Friday, September 19, 2014 3:59:16 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.
