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 |
|
nstout
Starting Member
8 Posts |
 Posted - 2001-05-18 : 15:01:08
|
| I need some code to quickly parse through a list of phone numbers that include alphanumeric characters and generate a new column that includes only the non-numeric numbers (ie. (123) 456-7890 --> 1234567890).Ideally, I'd like to compare the new list of "clean" numbers to an existing list of "numbers" to determine how many calls were generated for each number. Maybe there is a way to do this without removing all of the non-numeric numbers??? |
|
|
|
|
|
Removing nonnumeric characters from string