Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-12-06 : 13:15:31
|
| Beth writes "I am trying to change data imported from an outside datasource that has a varchar phone number field left open for individual user input. As expected there are too many variations in the field to work with easily, e.g., some have () around the area code, some have - between sections, some even have text at the end like 'SIS' to indicate a sister's number. How can I replace the existing data in this field with just the numbers and no other characters?" |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Deleting unwanted characters in a Phone Number 