DSXchange

I have an input column called the Telephone field which is varchar. It has data such as below:

Telephone

(999) 999 9999
999-999-9999
999 999 9999
999/9999999
999*9999999

How can I strip off all these special characters and just keep the numbers? I want a format like 9999999999.
I know I can strip the white space off but how should I deal with the other characters?
[/u]

Use the Convert() function to convert anything other than a number to a an empty space.

Thank you so much. It worked.