STUFF function [String]

Function

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

Syntax

STUFF ( string-expression1, start, length, string-expression2 )

Parameters

string-expression1 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-expression2 The string to be inserted.

Example

The following statement returns the value “chocolate pie”:

SELECT STUFF( 'chocolate cake', 11, 4, 'pie' )
FROM iq_dummy

Usage

To delete a portion of a string using STUFF, use a replacement string of NULL. To insert a string using STUFF, use a length of zero.

Standards and compatibility

See also

“INSERTSTR function [String]”