sql - phone numbers

From: Gregory Caulton <gcaulton_at_sympatico.ca>
Date: Thu, 14 Oct 1999 16:02:11 GMT
Message-ID: <3805FDE7.776A97F9@sympatico.ca>

If I have a column with phone numbers in a variety of formats

    e.g. 555-555 5555

             (555)555-5555
            5555555555

and what it to insert into a column that is numeric i.e. I need to change all of them to a number, what is the best way, I seem to get 'invalid number' often when trying to mix to_number, translate and nvl together into my insert.

thanks!

Greg Received on Thu Oct 14 1999 - 11:02:11 CDT