Yet another blog
REPLACE in T-SQL
Replace () is used to replaces all occurrences of a specified string value with another string value.
REPLACE ( string_expression , string_pattern , string_replacement )
Where string_expression is the string to be searched , string_pattern is the substring that needs to be searched and string_replacement is the string which will replace the string_pattern
The output would be godwasgreat. It searched for the string “is” within the string “godisgreat” and replaced the occurance of “is” with “was”.
The output would be godwasgreatwas.