Searching TEXT column

[Bob Barrows [MVP]]

John Smith wrote:

> I have a table that contains a column with datatype text. I would like
> to search through every row in the table and find a string of
> characters in the text column and replace it. Unfortunately, the SQL
> Server I am working with does not have full-text indexing installed
> (nor can it be installed). Can anyone show me how to best accomplish
> this?
>
>
> Thank you!

This should help:
[url]http://www.sqldudes.com/spreplacecharacters.htm[/url]

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Aaron [SQL Server MVP]]

[url]http://www.aspfaq.com/2445[/url]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"John Smith" <3rtwemte001@sneakemail.com> wrote in message
news:jqc0d01kcheqb26qin7lsc33ocedjf2hki@4ax.com...

> I have a table that contains a column with datatype text. I would like
> to search through every row in the table and find a string of
> characters in the text column and replace it. Unfortunately, the SQL
> Server I am working with does not have full-text indexing installed
> (nor can it be installed). Can anyone show me how to best accomplish
> this?
>
>
> Thank you!
>
>