Special Charcters

ppp · Post by **ppp** » Thu Feb 25, 2010 1:47 pm

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]

DSguru2B · Post by **DSguru2B** » Thu Feb 25, 2010 2:12 pm

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

ppp · Post by **ppp** » Thu Feb 25, 2010 2:45 pm

Thank you so much. It worked.