When to use STUFF instead of REPLACE – SQL Server

Excellent example that shows when to use STUFF instead of REPLACE in SQL Server