SQL Server/T-SQL/String Functions/STUFF

STUFF(): replace a portion of a string with another string

1> -- STUFF(): replace a portion of a string with another string.
2>
3> SELECT STUFF("Please submit your payment for 99.95 immediately.", 32, 5, "109.95")
4> GO
--------------------------------------------------
Please submit your payment for 109.95 immediately.
(1 rows affected)
1>
2>

STUFF(string_used_as_basis, start_point, length, string_to_insert)

1> -- STUFF(string_used_as_basis, start_point, length, string_to_insert)
2>
3> SELECT STUFF("Count Dracula is a vampire",20,7,"showoff")
4> GO
--------------------------
Count Dracula is a showoff
(1 rows affected)
1>