[firebird-support] Remove non numeric characters

[Köditz, Martin martin.koed...@it-syn.de [firebird-support]]

Hi,

I want to remove non numeric characters from my values. I haven’t found a 
solution with regex. So I do it this way:

What I have: +49.511 1234 567
What I want: 4951112234567

select
'+49.511 1234 567' as WHAT_I_HAVE,
REPLACE(REPLACE(REPLACE(REPLACE('+49.511 1234 567', ' ', ''), '-', ''), '+', 
''), '.', '') as WHAT_I_WANT
FROM RDB$DATABASE

I find this solution very ugly. Is there a more suitable way to remove the non 
numeric values?

Regards
Martin