SQL ServerSTUFF() Function
Example
Delete 3 characters from a string, starting in position 1, and then insert "HTML" in position 1:
SELECT STUFF('SQL Tutorial', 1, 3, 'HTML');
Try it Yourself »Definition and Usage
The STUFF() function deletes a part of a string and then inserts another part into the string, starting at a specified position.
Tip: Also look at theREPLACE() function.
Syntax
STUFF(string,start,length,new_string)
Parameter Values
| Parameter | Description |
|---|---|
| string | Required. The string to be modified |
| start | Required. The position instring to start to delete some characters |
| length | Required. The number of characters to delete fromstring |
| new_string | Required. The new string to insert intostring at thestart position |
Technical Details
| Works in: | SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse |
|---|
More Examples
Example
Delete 1 character from a string, starting in position 13, and then insert " is fun!" in position 13:
SELECT STUFF('SQL Tutorial!', 13, 1, ' is fun!');
Try it Yourself »
