title: There's what appears to be an EOT (end of text) character in my data in a SQL table that I need to remove
body: <p>How do I remove an "end of text" character from a field in a SQL table?  I'm using SQL Server 2012.  In a nutshell, the client provides me a data file in CSV format.  This data file:</p>
  
  <p><img src="https://i.stack.imgur.com/zUT8m.png" alt="enter image description here"></p>
  
  <p>When I copy/paste this weird, backwards L character into Sublime Text Editor:
  <img src="https://i.stack.imgur.com/KMsbh.png" alt="enter image description here"></p>
  
  <p>So, this is how I came up to the conclusion that this is an EOT character.  You're probably thinking at this point, this isn't in SQL.  You're right - but how we import data through our proprietary software is we "import" this file which will end up in a sort of "staging" dataset.  I then can apply a SQL query to strip this weird, non-alphanumeric character from this dataset.</p>
  
  <p>So, how would I remove this character using a SQL query, and what is the appropriate way to do this?  Meaning, do I use the ASCII equivalent of this EOT character when doing a SQL <code>REPLACE</code>?</p>