title: How can I check if an SQL result contains a newline character?
body: <p>I have a varchar column that contains the string <code>lol\ncats</code>, however, in SQL Management Studio it shows up as <code>lol cats</code>.</p>
  
  <p>How can I check if the <code>\n</code> is there or not?</p>