Remove NewLine characters from the data in SQL Server

I found that some string in the database have NewLine characters where they do not required. To remove them in T-SQL I wrote the following SQL script (TODO: write re-usable SP, also special option to remove NewLine characters from the end of the string)

geekswithblogs.net