Re: Phone Formatting Procedure
From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Mon, 4 Nov 2002 10:25:05 -0000
Message-ID: <1Wrx9.26490$zX3.67262_at_news.indigo.ie>
Date: Mon, 4 Nov 2002 10:25:05 -0000
Message-ID: <1Wrx9.26490$zX3.67262_at_news.indigo.ie>
as select '('||substr(phone,0,3)||')
unwanted characters - put a filter view over it or alternatively clean up
the data.
'||substr(phone,4,3)||'-'||substr(phone,8,4)) from contacts
"Fulano D. Tal" <fulano_at_dtal.net> wrote in message
news:E%Iw9.38836$bt.48618_at_rwcrnsc52.ops.asp.att.net...
> 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.
>
> Does anybody know of a procedure that I can leverage?
>
> TIA
>
Received on Mon Nov 04 2002 - 11:25:05 CET