title: Entering a New line in column data in SQL Server
body: <p>I am required to enter data in the column Text(nvarchar(max)) of a table 'Message' such that it will have the new line carriages in it. Selecting the column of the table would display the data in new lines. 
  I have tried inserting the string with CHAR(13), but it does not work.
  Is it possible to achieve that?</p>