Loading lesson path
Concept visual
Start at both ends
Delete 3 characters from a string, starting in position 1, and then insert "HTML" in position 1:
SELECT STUFF('SQL Tutorial', 1, 3, 'HTML');The STUFF() function deletes a part of a string and then inserts another part into the string, starting at a specified position.
Also look at the REPLACE() function.
string, start, length, new_string )
Required. The string to be modified start Required. The position in string to start to delete some characters length Required. The number of characters to delete from string new_string Required. The new string to insert into string at the start position
SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse
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!');❮ SQL Server Functions