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 - 04:25:05 CST
