I want to remove all the numeric characters from a string in SQL, e.g. Från Japan samtal till 0046709757417
I want the output to be Från Japan samtal till
thanks.
regexp_replace('Från Japan samtal till 0046709757417', '[0-9]', '')
SQLFiddle example: http://sqlfiddle.com/#!4/d41d8/24449
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With