SQL Replace()

Replaces all occurrences of a specified string value with another string value.

Syntax
REPLACE ( string_expression , string_pattern , string_replacement )

Example
select REPLACE(‘holca’,’c’,») –hola