SQL REPLACE()

Replace function, replaces a given set of characters in a string with another set of characters.

 REPLACE('STRING',character_1, character_2)

Online Execute/Compile
select replace(name,'T','Z') as T_to_Z FROM customers ;