title: Insert New Line in SQL for Variable String
body: <p>I am trying to add a new line into a string within SQL that has an XML output. The string that is outputted is a variable that is the concatenation of 2 column values. I have tried adding char(13) + char(10) between the two values to make a new line but to no avail. Is it possible that this cannot be done because it is being read as one string and not 2 individual strings?</p>
  
  <pre><code> @BilledName = B.BilledName + char(13) + char(10) + C.Company
  </code></pre>
  
  <p>the example above is a snippet of how I am trying to accomplish the task but will not return the expected value of BilledName on line 1 and Company on line 2.</p>
  
  <pre><code> BilledName
   Company
  </code></pre>
  
  <p>I am receiving the following:</p>
  
  <pre><code> BilledName  Company
  </code></pre>