Subject | Stripping non numerics from a string column |
---|---|
Author | Rich Pinder |
Post date | 2007-07-19T23:00:10Z |
I was hoping not to have to write my own function, but I'm not finding
anything build in to help update columns by stripping characters from a
string. I'd like to use SQL alone to accomplish the update.
Phone numbers is the issue
Would like to translate 818) 450-2345 into 8189097749
Generally, anything which is not a numeral (0-9), I'd like to strip
Thanks in advance for any points
Rich Pinder
USC School of Medicine
anything build in to help update columns by stripping characters from a
string. I'd like to use SQL alone to accomplish the update.
Phone numbers is the issue
Would like to translate 818) 450-2345 into 8189097749
Generally, anything which is not a numeral (0-9), I'd like to strip
Thanks in advance for any points
Rich Pinder
USC School of Medicine