Use the replace function in TSQL.

Hope this is what you are looking for