What is the STUFF function and how does it differ from the REPLACE function?

Q

What is the STUFF function and how does it differ from the REPLACE function?

✍: Guest

A

Answer1:
stuff-> inserts into it without removing any thing. Replace->replace the given text with the new one.

Answer2:
STUFF - it deletes a specified length of characters and inserts another set of characters at a specified starting point. REPLACE -Replaces all occurrences of a specified string value with another string value.

2014-10-13, 1460👍, 0💬