<barbaranesbitt@bellsouth.net> wrote in message
news:zTVed.24999$qH3.2501@bignews6.bellsouth.net...
> I need to replace some characters on an ntext column. However, the
REPLACE
> function won't work with the ntext column type. I know that I can cast to
a
> varchar(8000) and then call the function but I might truncate the data
that
> way. Is there a way that I can safely do this?
> Thanks

"Chris Hohmann" <nospam@thankyou.com> wrote in message
news:uzuea5huEHA.2856@TK2MSFTNGP15.phx.gbl...
> <barbaranesbitt@bellsouth.net> wrote in message
> news:zTVed.24999$qH3.2501@bignews6.bellsouth.net...
>> I need to replace some characters on an ntext column. However, the
> REPLACE
>> function won't work with the ntext column type. I know that I can cast
>> to
> a
>> varchar(8000) and then call the function but I might truncate the data
> that
>> way. Is there a way that I can safely do this?
>> Thanks
>
> http://www.aspfaq.com/show.asp?id=2445
>
>