I have a phone number field in my database which is varchar and so it can contain characters like "+", "(" etc.
I would like to extract the numbers and remove the other characters.
I have googled the topic and tried a combination of substring and patindex but I can't seem to work it out.
If I had "386(+224)74769111908" in my field, how I would I achieve "38622474769111908"?
Thanks in advance