User Id :    Password :      New Member   Forgot Password  
Topic: When and where to use STUFF function in SQL Server and how it is different from replace
Sachin Jain
29 Oct 2010 at 11:13 PM
When and where to use STUFF function in SQL Server and how it is different from replace.
Re: When and where to use STUFF function in SQL Server and how it is different from replace
Gaurav
01 Nov 2010 at 12:24 AM
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 occurrence. 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.
Total Replies: 1
 
Featured Text Ad

Featured Ad