Returns a character string created by replacing a specified number of characters in a character expression with another character expression.

STUFF(cExpression, nStartReplacement, nCharactersReplaced, cReplacement)

Parameters

cExpression

Specify the character expression in which the replacement occurs.

nStartReplacement

Specifies the position in cExpression where the replacement begins.

nCharactersReplaced

Specifies the number of characters to be replaced. If nCharactersReplaced is 0, the replacement string cReplacement is inserted into cExpression.

cReplacement

Specifies the replacement character expression. If cReplacement is the empty string, the number of characters specified by nCharactersReplaced are removed from cExpression.

Return Value

Example

	Copy Code
STORE 'abcdefghijklm' TO gcString1 STORE '12345' TO gcString2 CLEAR ? STUFF(gcString1, 4, 0, gcString2) && insert ? STUFF(gcString1, 4, 3, gcString2) && replace ? STUFF(gcString1, 4, 6, '') && delete ? STUFF(gcString1, 4, 1, gcString2) && replace and insert ? STUFF(gcString1, 4, 4, gcString2) && replace and delete ? STUFF(gcString1, 4, LEN(gcString1), gcString2) && replace, delete rest

See Also