I want to "delete" (to replace with null) all occurrences of a character . from a string. In fact i have to create a view with phone numbers. For the phone_number field in the database i have some values like this one: 126.96.36.199.90 and I must display it without . character (1234567890).
It could be done with regular expression. But I'm beginner at this part and i need some help.
Another solution it's to create a function for that, but i hope that could be do more easily.