removing unwanted characters

[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

 

[Ken Snell [MVP]]

Check out Replace function and Update Query in Help files.