I am working in a SQL Server 2000 database and have a new requirement to convert the [Comments] filed to "NTEXT". Can anyone help me convert the code below to allow the data to be stored in "NTEXT"? It currently works if the field is varchar but the data requirements for this field has greatly increased so I need to change it to "NTEXT". Any and all help in this matter is greatly appreciated.

[Comments] = [Comments] + '[Auto de-escalted as infringement ' + Cast(@InfringementId as nvarchar) + ' marked inactive.]'