SQL formatting question

[Eric Creese]

I have a table with column of phone numbers. The phone numbers have been entered in a number of different formats some containing . or - or /. Some with area codes with (). What I want to do is get them all the same. Now I can take all the records and get them all in a simple 10 digit sequence but I then want to convert them all to (123)456-7890 format. The field that houses the phone number is a varchar(50) field.

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---