Standardize SQL Server data with text lookup and replace function

(Greg Robidoux) Have you ever had the need to replace multiple words in a data column with a new word or a new phrase for an entire table? A good example would be to update a product catalog with new words either for standardization or just to reflect a new name for the product.