REPLACE() It is used to replace all the occurrences of the second argument in the first argument with the third argument. Syntax: REPLACE (String, StringPattern, StringTobeReplaced) Ex: SELECT REPLACE (‘SQLVERSITY is a good website’, ‘good’, ‘great’) Output: SQLVERSITY is a great website STUFF()

Read More