title: Cast string+ntext to nvarchar error
body: <p>I am trying to cast a string and a column value concatenated with the following sql commant:</p>
  
  <pre><code> CAST('Strign:'+[KlirAn] as NVARCHAR(max))
  </code></pre>
  
  <p>After executing this command i get the following error:</p>
  
  <pre><code>    Msg 402, Level 16, State 1, Line 1
  The data types varchar and ntext are incompatible in the add operator.
  </code></pre>
  
  <p>Any help please?</p>