Subject Stripping non numerics from a string column
Author Rich Pinder
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