SQL Server Transact Basic to Expert - Replace a portion of string

This blog shows how to replace a portion of the string with a new string in SQL Server

Example:

SELECT REPLACE('This is a sample test string used to replace',
            'test',
            'text')


Expected result would be "This is a sample text string used to replace"