What does the REPLACE function do in SQL?

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