Returns a string with specified characters removed and others inserted in their place.

Syntax

<expC>.stuff(<start expN>, <quantity expN> [, <replacement expC>])

<expC>

The string in which you want to remove and replace characters.

<start expN>

The character position in the string at which you want to start removing characters.

<quantity expN>

The number of characters you want to remove from the string.

<replacement expC>

The characters you want to insert in the string. By default, this is an empty string.

Property of

String

Description

This method is almost identical to the STUFF( ) function. However, the stuff( ) method is zero-based (the function is one-based), a replacement string is optional, and the method defaults to an empty string.