title: SQL query for a carriage return in a string and ultimately removing carriage return
body: <p>SQL query for a carriage return in a string and ultimately removing carriage return</p>
  
  <p>I have some data in a table and there are some carriage returns in places where I don't want them. I am trying to write a query to get all of the strings that contain carriage returns.</p>
  
  <p>I tried this</p>
  
  <pre><code>select * from Parameters
  where Name LIKE '%"\n" %'
  </code></pre>
  
  <p>Also</p>
  
  <pre><code>select * from Parameters
  where Name LIKE '\r'
  </code></pre>
  
  <p>'</p>
  
  <p>Both are valid SQL but are not returning what I am looking for. Do I need to use the <em>Like</em> command or a different command? How do I get the carriage return into the query?</p>
  
  <p>The carriage return is not necessarily at the end of the line either (may be in the middle).</p>