Stuff in SQL Server: STUFF Function in SQL Server

Stuff in SQL Server: STUFF Function in SQL Server is easier to understand when the core ideas are paired with practical examples. The sections below explain the topic clearly, highlight useful steps, and point out details that can prevent common errors.

The article will explore and show you how to use the STUFF function to insert a string into another string in SQL Server.

Describe

STUFF function in SQL Server helps insert a string into another string, the result returned is a new string after canceling some existing characters and adding another substring at the canceled location.

Syntax

To use STUFF function in SQL Server, we use the following syntax:

 STUFF(string, start, length, new_string)

 SELECT STUFF('TipsMake.com', 1, 11, 'Meta'); 
 Result: 'Meta.com' 
 
 SELECT STUFF('Tipsmake.com', 5, 3, '1234'); 
 Result: 'Quan1234Mang.com' 
 
 SELECT STUFF('Tipsmake.com', 12, 4, ' la website thong tin dien tu'); 
 Result: ' Tipsmake la website thong tin dien tu'

FAQ

What should you know about describe?

STUFF function in SQL Server helps insert a string into another string, the result returned is a new string after canceling some existing characters and adding another substring at the canceled location.