Skip to content

Commit 3a8b60e

Browse files
authored
1 parent d2bf871 commit 3a8b60e

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

docs/t-sql/functions/stuff-transact-sql.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -46,7 +46,7 @@ STUFF ( character_expression , start , length , replaceWith_expression )
4646
Is an integer value that specifies the location to start deletion and insertion. If *start* is negative or zero, a null string is returned. If *start* is longer than the first *character_expression*, a null string is returned. *start* can be of type **bigint**.
4747

4848
*length*
49-
Is an integer that specifies the number of characters to delete. If *length* is negative, a null string is returned. If *length* is longer than the first *character_expression*, deletion occurs up to the last character in the last *character_expression*. If *length* is zero, insertion occurs before the first character in the string. *length* can be of type **bigint**.
49+
Is an integer that specifies the number of characters to delete. If *length* is negative, a null string is returned. If *length* is longer than the first *character_expression*, deletion occurs up to the last character in the last *character_expression*. If *length* is zero, insertion occurs at *start* location and no characters are deleted. *length* can be of type **bigint**.
5050

5151
*replaceWith_expression*
5252
Is an [expression](../../t-sql/language-elements/expressions-transact-sql.md) of character data. *character_expression* can be a constant, variable, or column of either character or binary data. This expression replaces *length* characters of *character_expression* beginning at *start*. Providing `NULL` as the *replaceWith_expression*, removes characters without inserting anything.

0 commit comments

Comments
 (0)