It's a poor idea, because it's going to take significant server resources each time you do it: If you have a large number of rows (or do this frequently) you are going to waste a lot of Server processing time!
I'd recommend that either you allocate a second column which holds only the numeric values and insert that when you insert the other column, or do this in your presentation language where a simple regex will do it and distribute the load across different machines.
But...you can do it:
tsql - T-SQL select query to remove non-numeric characters - Stack Overflow[
^] - see the SQL function given by eDriven_Levar at the bottom.
I really don't recommend it though.