Small function to replace characters with SQL Server A small function utilizing CTE to replace undesired characters from a string Click here to read the article
