Thanks!
"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message
news:1Wrx9.26490$zX3.67262_at_news.indigo.ie...
> as select '('||substr(phone,0,3)||')
> '||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" <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 - 23:51:14 CST
