SQL Server Transact Basic to Expert - Stuffing string into a string

This blog shows how to stuf a string into a string using the STUFF function in SQL server

Syntax:

STUFF ( character_expression, start, length, character_expression )


Example:

STUFF ('This is a X string', 11, 1, 'Valid')

The expected result would be This is a Valid String