<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>

The only way would be to convert your text field into an nvarchar field.
```
```
Select Cast(notes as nvarchar(4000)) + 'SomeText'
From NotesTable a
```
```
Otherwise, I suggest doing the concatenation in your application.