Thanks Nigel,
I will follow the examples given already for writing a SP - just
wondered first if I was missing something built in.

ref: http://tech.groups.yahoo.com/group/firebird-support/message/68619

r

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
>
>