Returns a character string created by replacing a specified number of characters in a character expression with another character expression.
STUFFC(cExpression, nStartReplacement, nCharactersReplaced, cReplacement)
- Specify the character expression in which the replacement occurs.
- Specifies the character position in cExpression where the replacement begins.
- Specifies the number of characters to be replaced. If nCharactersReplaced is 0, the entire replacement string cReplacement is inserted into cExpression.
- Specifies the replacement character expression. If cReplacement is the empty string, the number of characters specified by nCharactersReplaced are removed from cExpression.
STUFFC(В ) is designed for expressions containing double-byte characters. If the expression contains only single-byte characters, STUFFC(В ) is equivalent to STUFF(В ).
STUFFC(В ) returns a character string created by replacing a specified number of characters in a character expression with another character expression. The character expressions can consist of any combination of single-byte and double-byte characters.
This function is useful for manipulating double-byte character sets for languages such as Hiragana and Katakana.