STUFF and REPLACE function in SQL

Question

Hi!!

Can someone tell me how to use the STUFF and REPLACE function in SQL?

Answer 1

STUFF Function: This function is used to overwrite existing character or inserts a string into another string. Syntax:

STUFF(string_expression,start, length, replacement_characters)

where,

• string_expression: it is the string that will have characters substituted
• start: This refers to the starting position
• length: It refers to the number of characters in the string which are substituted.
• replacement_string: They are the new characters which are injected in the string.

REPLACE function: This function is used to replace the existing characters of all the occurrences. 

Syntax:

REPLACE (string_expression, search_string, replacement_string)

Here every search_string in the string_expression will be replaced with the replacement_string.