title: How to manipulate ntext type data in stored procedure of SQL Server 2008
body: <p>I was wondering how to manipulate ntext  datatype in stored procedure of SQL Server 2008.
  We have a column of type ntext in a table. We have to fetch data from that column, parse the data, change and then store it back.
  For all of the above task we have to use one or more than on stored procedure/function. So data passing between stored procedures are also involved.</p>