For that, I would use a function with PATINDEX to retain only the desired chars.

If performance is not an issue, you can use a scalar function.

I can give you a sample function if you would like. I wrote somewhat similar functions to do "remove all non-alpha, non-numeric" chars and duplicate Oracle's "InitCap" function (first letter of each word is upper case, remaining letters of same word are all lower case).