title: Replacing weird control characters from sql server table
body: <p>I have a sql server table where control characters appear when column is copied and pasted into notepad. I need to remove/replace these control characters. For example here is a text i copied from my sql server table into notepad</p>
  
  <p><a href="https://i.stack.imgur.com/TuEFD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TuEFD.png" alt="enter image description here"></a></p>
  
  <p>How do i remove "OSC". I have searched the net and here but cant find anything on this. Table was imported from SSIS as ANSI (i also tried data conversion in ssis to convert the column to ascii but still to no avail). </p>