Remove Newline Tab Character in Data using SQL Server

While working on an application, I came across a small column with some Newline and Tab characters in it. The requirement was to replace these characters. Here’s how to remove/replace the Newline characters in your data. I will demonstrate this example with a string, but you can easily replace it with a column name DECLARE @str as nvarchar(70)SET @str = 'APPT 5212NORTH BLOCK, 7th AvMUMBAI,