Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Phone Formatting Procedure
0 views
Skip to first unread message
Fulano D. Tal
Nov 2, 2002, 12:02:28 AM11/2/02
to
I'm working on a procedure that will format an existing column of phone
numbers into (xxx) xxx-xxxx format - at the same time cleaning up any
unwanted characters.
numbers into (xxx) xxx-xxxx format - at the same time cleaning up any
unwanted characters.
Does anybody know of a procedure that I can leverage?
TIA
Telemachus
Nov 4, 2002, 5:25:05 AM11/4/02
to
as select '('||substr(phone,0,3)||')
'||substr(phone,4,3)||'-'||substr(phone,8,4)) from contacts
'||substr(phone,4,3)||'-'||substr(phone,8,4)) from contacts
unwanted characters - put a filter view over it or alternatively clean up
the data.
"Fulano D. Tal" <ful...@dtal.net> wrote in message
news:E%Iw9.38836$bt.4...@rwcrnsc52.ops.asp.att.net...
Fulano D. Tal
Nov 5, 2002, 12:51:14 AM11/5/02
to
Thanks!
"Telemachus" <telem...@ulysseswillreturn.net> wrote in message
news:1Wrx9.26490$zX3....@news.indigo.ie...
0 new messages