removing unwanted characters

A

Alex H

Hi can someone help me please

I am trying to clean up my telephone field in a database. This field
currently contains the '+44' country code and then either spaces or '-'
between sets of numbers.

Has anyone and ideas how i can remove the unwanted charaters using a query?

many thanks

A
 
Top