STUFF(): replace a portion of a string with another string : STUFF « String Functions « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. String Functions
  3. 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>








Related examples in the same category

1.STUFF(string_used_as_basis, start_point, length, string_to_insert)