SQL Server Replace Command With WIldcard

I am in need of some help. Thanks to fellow user davids, I was able to get certain things working within SQL Server and am in need of some more help. Here is what I am trying to do

Solution 1:

You should look into regular expressions.

My google karma found this article in MSDN Magazine.

Edit:

See also: Perform regex (replace) in an SQL query