Tuesday, January 6, 2004, 7:03:36 PM, you wrote:
EC> I have a table with column of phone numbers. The phone
EC> numbers have been entered in a number of different formats some
EC> containing . or - or /. Some with area codes with (). What I want
EC> to do is get them all the same. Now I can take all the records and
EC> get them all in a simple 10 digit sequence but I then want to
EC> convert them all to (123)456-7890 format. The field that houses
EC> the phone number is a varchar(50) field.
EC>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
