STUFF function in SQL

Hi Manish,

STUFF function to overwrite existing characters. Using this syntax, STUFF(string_expression, start, length, replacement_characters), string_expression is the string that will have characters substituted, start is the starting position, length is the number of characters in the string that are substituted, and replacement_characters are the new characters interjected into the string.
REPLACE function to replace existing characters of all occurance. Using this syntax REPLACE(string_expression, search_string, replacement_string), where every incidence of search_string found in the string_expression will be replaced with replacement_string.

Please refer the below link

http://blog.sqlauthority.com/2007/04/19/sql-server-interview-questions-part-5/

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak14y ago
Hi Manish,

STUFF function to overwrite existing characters. Using this syntax, STUFF(string_expression, start, length, replacement_characters), string_expression is the string that will have characters substituted, start is the starting position, length is the number of characters in the string that are substituted, and replacement_characters are the new characters interjected into the string.
REPLACE function to replace existing characters of all occurance. Using this syntax REPLACE(string_expression, search_string, replacement_string), where every incidence of search_string found in the string_expression will be replaced with replacement_string.

Please refer the below link

http://blog.sqlauthority.com/2007/04/19/sql-server-interview-questions-part-5/

Thanks
Vulpes14y ago
You asked the same question on 20 August:

http://www.c-sharpcorner.com/Forums/Thread/183672/stuff-function-in-in-sql-server.aspx