I apologize, new to this.

I do not know how to do what you are asking. Again, I am sorry, but I do appreciate your effort. Thank you.

Thank you Phil. Please see attached.

What happened is that Company A was purchased by Company B. Neither company is in the tech industry.

I have been trying to help my friend, an employee of Company A,...

Jeff,

Like this?

SELECT ca1.ClientNotes
FROM ClientDetails
UPDATE (
    SELECT REPLACE(REPLACE(REPLACE(ClientNotes, CHAR(9), ''), CHAR(10), ''), CHAR(13), '') as 'ClientNotes' 
) AS ca1

The export is too large to open in Notepad, but opening the file in Word shows the breaks are there after export.

I am not sure what else you are looking...

Thank you for the reply. I tried that and the values in the original column are still the same.  Should that have output to a new column?

I created a new...

Lowell - Yes, we would want to replicate all databases contained within an instance. Being in way over my head at this point, I hope that you have better luck...