STUFF function [String]

Deletes a number of characters from one string and replaces them with another string.

Syntax
STUFF( string-expression-1, start, length, string-expression-2 )
Parameters
  • 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.

Remarks

This function supports NCHAR inputs and/or outputs.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

The following statement returns the value chocolate pie.

SELECT STUFF( 'chocolate cake', 11, 4, 'pie' );