Changing number format

From: anurag <aminochaNOamSPAM_at_unibiz.com.invalid>
Date: Mon, 14 Aug 2000 15:05:14 -0700
Message-ID: <02fed1ae.683e366b@usw-ex0104-033.remarq.com>

HI,

I have a column with phone numbers inserted. It is a varchar column and the numbers are inserted in the form 3013971234.

I need to update the column so that the numbers should now appear as 301-397-1234.
Also some numbers might have the area code and some might not example 9996576 and they need to be updated to 999-6576.

I am unable to write an update statement to do this.

Any help will be appreciated.

Thanks
Anurag

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Mon Aug 14 2000 - 17:05:14 CDT