Subject Re: [firebird-support] Stripping non numerics from a string column
Author Rich Pinder
Thanks Nigel,
I will follow the examples given already for writing a SP - just
wondered first if I was missing something built in.



Rich Pinder wrote:
> 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