I made a careless Mistake. I was actually concatenation my varchar
variable with the ntext
variable. As Ntext
concatenation is not allowed, I got stuck.
solved SQL Server 2000: Invalid operator for data type. Operator equals add, type equals ntext