Avatar of Muskie12

asked on 

Edit MSAccess query to clean up phone field

I have a query that displays phone numbers and they have mixed in various brackets, spaces and dashes. I need to remove any special characters like that and just have the numbers displayed (i.e. 1231231234).

The solution that I did find involves pasting code into a public function which I don't know how to do.
Microsoft AccessMicrosoft SQL ServerMySQL Server

Avatar of undefined
Last Comment
Anthony Perkins

8/22/2022 - Mon