Because we search on them. & my people DO NOT like change.
Dick Fey
On 9/19/2014 4:15 PM, Albert Berry wrote:
Why not simply format them on output?
Albert
On 9/19/2014 2:37 PM, Richardson, Jeff wrote:
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.
