title: Convert "\n" to actual newline in SQL Server
body: <p>I have a bunch of varchar(255) and varchar(max) fields in a table in MS SQL Server.</p>
  
  <p>These are generally formatted messages (email and other). Most of the fields have the actual characters "\n", but actually need a newline character. I don't need to worry about new data going forward, but don't know how to fix the stuff that's currently in the DB. </p>
  
  <p>I'm mostly a programmer, not a SQL/DB Guy, so any pointers on how to approach fixing this, or resources to get me started would be appreciated.</p>