Mega Code Archive

 

Categories / MSSQL / String Functions

 

STUFF()

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>