I have a phone number inside a field called 'phone'
I need to remove all formatting (parenthesis, dashes, spaces) and leave the numbers only.
I have the sql below but it only removes dashes, can I get help to remove everything but digits ? or to additionally remove parenthesis open and close and spaces ?
Replace(PobCountry,'-','') AS phoneclear