SQL Server strings section provides example to manage strings with the common functions.
How to replace a specific string into a column of a text variable with SQL Server REPLACE function. Or how to replace line breaks with the CHAR function.
Learn how to split a long text into multiple lines using XML data type, the CONVERT and the REPLACE function.