Is there a way to use a function like Replace on a Text data type?

20 Jul 2006 8:04 PM

awd

Hello,

The subject really says it all. Is there a way to perform the same job
as Replace when the column is a Text data type?

Thanks,
Anthony

20 Jul 2006 8:23 PM

Narayana Vyas Kondreddi

Here's an example using UPDATETEXT function:
http://www.sqlteam.com/item.asp?ItemID=15528

--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/

Show quote

"awd" <awdigrig***@gmail.com> wrote in message
news:1153425843.846415.44980@m79g2000cwm.googlegroups.com...
> Hello,
>
> The subject really says it all. Is there a way to perform the same job
> as Replace when the column is a Text data type?
>
> Thanks,
> Anthony
>

21 Jul 2006 1:44 PM

awd

Thank you. That solves my problem completely.

Narayana Vyas Kondreddi wrote:
Show quote

> Here's an example using UPDATETEXT function:
> http://www.sqlteam.com/item.asp?ItemID=15528
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
>
>
>
> "awd" <awdigrig***@gmail.com> wrote in message
> news:1153425843.846415.44980@m79g2000cwm.googlegroups.com...
> > Hello,
> >
> > The subject really says it all. Is there a way to perform the same job
> > as Replace when the column is a Text data type?
> >
> > Thanks,
> > Anthony
> >

21 Jul 2006 3:24 AM

Steve Kass

One option is to upgrade to SQL Server 2005 and change the [text] columns to
varchar(max), which supports the REPLACE() function.

Steve Kass
Drew University
www.stevekass.com

Show quote

"awd" <awdigrig***@gmail.com> wrote in message
news:1153425843.846415.44980@m79g2000cwm.googlegroups.com...
> Hello,
>
> The subject really says it all. Is there a way to perform the same job
> as Replace when the column is a Text data type?
>
> Thanks,
> Anthony
>