title: How do I concatenate a large Text datatype in SQL Server
body: <p>I have the next query:</p>
  
  <pre><code>select 'some text: ' + cast(description as varchar(8000)) + ' end text'
  From descriptionTable
  </code></pre>
  
  <p>but my description field it's larger than 8000 chars, so what can I do?, or do I have to make an application.</p>
  
  <p>Thanks, </p>
  
  <p>j2gl</p>