title: How can I see all the "special" characters permissible in a varchar or char field in SQL Server?
body: <p>Where can I see all the non-visible characters stored on a <code>varchar</code> or <code>char</code> field in SQL Server? e.g. <code>\n</code> (new-line), <code>\r</code> (carriage return) and other &quot;non-printable&quot; characters?</p>
  <p>How to print them (as they are not printable but perform some action on the text)?</p>