REPLACE ( string_expression , string_pattern , string_replacement )

SELECT REPLACE ( 'closed won' , 'closed won', 'award')

the string_expression can be a column, variable, or string.