Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

The syntax for STUFF is STUFF(string_used_as_basis, start_point, length, string_to_insert)

5> 6> SELECT STUFF("ABCDEFGHIJKL",2,3,"sho") 7> GO ------------ AshoEFGHIJKL (1 rows affected)