-
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.
-
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
-
Forum Rules
|
|