title: Concatenate ntext in SQL Server 2005
body: <p>I need to concatenate 2 ntext columns into one. I can't convert them to nchar, cause both contains strings longer than 4000 chars.
  Is there a way to do this in SQL Server 2005?</p>