The syntax for STUFF is STUFF(string_used_as_basis, start_point, length, string_to_insert) : STUFF « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. STUFF
5>
6> SELECT STUFF("ABCDEFGHIJKL",2,3,"sho")
7> GO

------------
AshoEFGHIJKL

(1 rows affected)








12.21.STUFF
12.21.1.The syntax for STUFF is STUFF(string_used_as_basis, start_point, length, string_to_insert)
12.21.2.Stuffing a String into a String
12.21.3.STUFF(notes, PATINDEX('%computer[^s]%', notes),