Cast string+ntext to nvarchar error

Question

I am trying to cast a string and a column value concatenated with the following sql commant:

 CAST('Strign:'+[KlirAn] as NVARCHAR(max))

After executing this command i get the following error:

    Msg 402, Level 16, State 1, Line 1
The data types varchar and ntext are incompatible in the add operator.

Any help please?

Answer 1

Try the following:

'String:'+ CAST([KlirAn] as NVARCHAR(max))