title: Insert Line break in Case expression result SQL
body: <p>I have the following <code>Case</code> expression:</p>
  <pre><code>SELECT 
      CASE 
         WHEN item = '662627-4' 
            THEN 'KLX Licensed &amp; BOM CONTAINS KLX LICENSED PART(S)'
            ELSE NULL
  </code></pre>
  <p>The result is as follows:</p>
  <pre><code>KLX Licensed &amp; BOM CONTAINS KLX LICENSED PART(S)
  </code></pre>
  <p>I would like to have it display like this on two lines:</p>
  <pre><code>KLX Licensed &amp;
  BOM CONTAINS KLX LICENSED PART(S)`
  </code></pre>
  <p>Is this possible? Is there a character to insert a carriage return in the case statement?</p>
  <p>I'm using SQL Server 2016.</p>