Text, ntext and image are special data types that does not support the normal string operators.

If you want to concatenate, you'll need to cast each field into varchar or nvarchar first.