Need a query to remove all but numbers

I have 2 phone number columns. Whoever wrote the initial program had not restrictions or validation on what was entered, so it has random spacing, hyphens, parenthesis, n even a rare + sign. I want to remove anything that is not a number so all remaining values should be either 7, 10, or 11-digit numbers. How would I got about doing this?

He who knows not that he knows not is a fool, ignore him. He who knows that he knows not is ignorant, teach him. He who knows not that he knows is asleep, awaken him. He who knows that he knows is a leader, follow him.

I found a little something that kinda worked, but only defined items 1 at a time to remove. Granted this is a phone number field, so the characters I removed were +()- and space. I figure a more complete cleaning would be great in case more was typed in. Thanks for any input!

Code:

UPDATE ifr SET Telephone = REPLACE(Telephone,'-','')

He who knows not that he knows not is a fool, ignore him. He who knows that he knows not is ignorant, teach him. He who knows not that he knows is asleep, awaken him. He who knows that he knows is a leader, follow him.

Why canít I use certain words like "drop" as part of my Security Question answers?
There are certain words used by hackers to try to gain access to systems and manipulate data; therefore, the following words are restricted: "select," "delete," "update," "insert," "drop" and "null".

+ is shorthand for "International Access code".
So you can write your Australian international number as something like +61 2 3456 7890, which in Australia would mean 0011 61 etc, but in USA would mean 011 61 etc.

So, + is good. Don't remove it without replacing it with YOUR local International Access Code or you'll break the number.

So, + is good. Don't remove it without replacing it with YOUR local International Access Code or you'll break the number.

I am not wishing to avoid the +. The DB is just to hold a single strand of numbers, and they get formatted when placed onto the page, so the + is pretty much only for View mode.

He who knows not that he knows not is a fool, ignore him. He who knows that he knows not is ignorant, teach him. He who knows not that he knows is asleep, awaken him. He who knows that he knows is a leader, follow him.