Stuffing a String into a String : STUFF « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. STUFF
4>
5> SELECT STUFF ( 'www.java2s.com''s name is java2s. ',
6> 8,
7> 1,
8> 'Edgar' )
9> GO

-------------------------------------
www.javEdgar2s.com's name is java2s.

(1 rows affected)
1>








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),