Use of stuff Functions

Stuff

Delete characters of the specified length and insert another group of characters at the specified start point.

Syntax

Stuff(Character_expression, Start, Length, Character_expression)

Example

In the following example, three characters starting from the second position (character B) are deleted from the first string (abcdef), and the second string is inserted at the start position of the deletion, creates and returns a string.

Select stuff ('abcdef', 2, 3, 'ijklmn ') Go

The following is the result set:

--------- Aijklmnef