Using Replace In SQL

I really need to learn more about sql statements. So this is how to replace certain words/symbols in SQL statements.

In this example i select value from the field selected and add it to replace function and then add the symbol that you to replace at first parameter and symbol that you want it to be in second parameter.