title: How do I concatenate text in a query in sql server?
body: <p>The following SQL:</p>
  
  <pre><code>SELECT notes + 'SomeText'
  FROM NotesTable a 
  </code></pre>
  
  <p>Give the error:</p>
  
  <blockquote>
    <p>The data types nvarchar and text are incompatible in the add operator.</p>
  </blockquote>