Well taking a phone number formatted like (###)-###-#### and removing all the non-numeric characters is quite a bit different from your first post. Your first post is rather convoluted and obviously incorrect on many levels. I wanted sample data so I could show you how to do it better/more properly. But, since you don't see to want to bother, I'll show you how to use the REPALCE function to answer your last question. If you want help fixing your original query, then please post sample data.
DECLARE @Foo VARCHAR(20) = '(409)888-7777';
SELECT REPLACE(REPLACE(REPLACE(@Foo, '(', ''), ')', ''), '-', '')