STUFF function in SQL

Question

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

Satyapriya Nayak · Answer

Hi Varshika, 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

Rohatash Kumar · Answer

Stuff Function The Stuff function is used to replace characters in a string. This function can be used to delete a certain length of the string and replace it with a new string. Replace function Replace all occurrences of the second given string expression in the first string expression with a third expression. More... http://www.c-sharpcorner.com/UploadFile/rohatash/difference-between-stuff-and-replace-function-in-sql-server/

STUFF function in SQL

Answers (2)