Which of the following can be used to replace a specific set of characters with another set of characters?
A) SUBSTR
B) REPLACE
C) FNDRPLCE
D) none of the above

Question

​Which of the following can be used to replace a specific set of characters with another set of characters?
A) ​SUBSTR
B) ​REPLACE
C) ​FNDRPLCE
D) ​none of the above

Quizplus · Accepted Answer

The REPLACE function is used to replace a specific set of characters with another set of characters in a string. The SUBSTR function is used to extract a portion of a string based on starting position and length, and FNDRPLCE is not a standard SQL function.

​Which of the Following Can Be Used to Replace a Specific

Which of the Following Can Be Used to Replace a Specific