Global search and replace in SQL Server with data type ntext

microsoft.public.sqlserver.programming

21 Jul 2006 8:22 PM

msnews.microsoft.com

Hello,
I want to do a global search and replace in my SQL database where the data
type could also be "ntext". I did find the code which works for (char,
vachar, nchar, nvachar)

Thank you for your help
regards

31 Jul 2006 4:29 PM

caz

Hi,
i had the same problem .. i.e. search and replace on a ntext column...
The code in the following article works a treat.
http://www.aspfaq.com/show.asp?id=2445

hth..
Caroline.

msnews.microsoft.com wrote:
Show quote

> Hello,
> I want to do a global search and replace in my SQL database where the data
> type could also be "ntext". I did find the code which works for (char,
> vachar, nchar, nvachar)
>
> Thank you for your help
> regards