Today I came accross a problem where nvarchar data got larger than the maximum that can be stored in a record. I had to convert to a ntext column and append the data to it. I quickly found out that I needed to use the UPDATETEXT function in combination...