Results 1 to 2 of 2

Thread: I'm a new user. Imported large data set. Need help formatting with SQL!

  1. #1
    Join Date
    Mar 2003
    Posts
    1

    Question I'm a new user. Imported large data set. Need help formatting with SQL!

    I have imported a large data set into one table called USERS. One field is a phone number field called Contact_Number. Some numbers are listed with dashes and periods separating the area code and prefix. e.g. 555.555.5555 , and 555-555-5555.

    There are several thousand entries. How can I write a query that will remove the dashes and periods and just leave the phone numbers as one number without dashes. Any help would be appreciated.

  2. #2
    Join Date
    Mar 2003
    Location
    CA,USA
    Posts
    18

    SQL Function

    Hi mjk

    USe REPLACE function Oracle SQL

    select REPLACE('555-555-5555' ,'-') from dual
    /

    HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •