What does the REPLACE function do in SQL?

A Updates the value of a column in all rows matching a condition B Removes a specific character from a string C Substitutes all occurrences of a substring within a string with another substring D Replaces a row in a table if it exists or inserts it if it does not