Deletes a number of characters from one string and replaces them with another string.
STUFF( string-expression-1, start, length, string-expression-2 )
string-expression-1 The string to be modified by the STUFF function.
start The character position at which to begin deleting characters. The first character in the string is position 1.
length The number of characters to delete.
string-expression-2 The string to be inserted. To delete a portion of a string using the STUFF function, use a replacement string of NULL.
This function supports NCHAR inputs and/or outputs.
SQL/2003 Vendor extension.
The following statement returns the value chocolate pie.
SELECT STUFF( 'chocolate cake', 11, 4, 'pie' );