title: Is there any way to use newline character in SQL server Select Query
body: <blockquote>
    <p>The question is based on SQL Server not about ssrs NEW Line</p>
  </blockquote>
  
  <p>i had Already go through the stackoverflow below links related to this topic </p>
  
  <p>1)<a href="https://stackoverflow.com/questions/1085662/new-line-in-sql-query">New line in Sql Query</a></p>
  
  <p>2)<a href="https://stackoverflow.com/questions/18528471/new-line-in-sql-server">New line in sql server</a></p>
  
  <p>3)<a href="https://stackoverflow.com/questions/1085662/new-line-in-sql-query">New line in Sql Query</a></p>
  
  <p>But i didn't get any answer for my situation </p>
  
  <p>My problem is that i need a newline character in select query results </p>
  
  <p>Example : i have a string like below </p>
  
  <pre><code>Today is Friday Yesterday is Thursday
  </code></pre>
  
  <p>and when I select this varchar value from my table I need it to to appear like this in my SSRS report:</p>
  
  <pre><code>Today is Friday
  Yesterday is Thursday
  </code></pre>
  
  <p>I have tried many ways like </p>
  
  <pre><code>select 'Today is Friday' +char(13)+'Yesterday is Thursday'
  </code></pre>
  
  <p>but it gives me a result  <code>Today is Friday Yesterday is Thursday</code></p>
  
  <p>but when i use print insted of select then i got the results what i want 
  But i cannot use print in my scenario because i need this result in aother query and that query i have used for ssrs reporting purpose</p>
  
  <p>I know i can split this query and show it in two rows but in my case i can't do something like that too because the results i have used in many select querys.</p>
  
  <p>i don't know  it is possible in Sqlserver, if it is possible then 
   please help me to solve my problem </p>
  
  <p>Edit : please help me if it is possible in Grid Mode rather than text mode</p>