Small function to replace characters with SQL Server

This tip exemplifies building SQL function with CTE to effectively substitute undesirable characters in input strings for various operations.

Performance degradation may occur when using functions within WHERE clauses, including this one for character replacement.

The CTE approach shown is one method among several like regex or T-SQL loops to achieve character replacement.

Read at CodeProject