Searching TEXT column

[John Smith]

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!

[Bob Barrows [MVP]]

Re: Searching TEXT column

John Smith wrote:[color=blue]
> 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?
>
>[/color]
Please do not multipost John. This is definitely a database-related question
so .asp.db was the perfect group in which to post it. Posting it here as
well did not increase your chances of getting an answer (most of us
subscribe to both groups). On the contrary, if somebody had taken his time
to answer it here, only to find that it was already resolved in the other
group, that person may have been annoyed enough to ignore any future posts
from you, thereby decreasing your chances of getting help in the future.

There are times when you will not be sure which group is most appropriate,
and you will want to post a question to both groups. In that situation, you
should use the cross-posting technique, rather than posting the same message
multiple times. To crosspost, put a semicolon-delimited* list of the
newsgroups to which you wish to post in the To: header of your post and post
it once. It, and any replies to it, will appear in all the newsgroups in
your list. So, if I reply in .asp.db, my reply will also appear here in
..asp.general.

* ... or whatever delimiter is recognized by your news client

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.

[dave]

Re: Searching TEXT column

Crossposting vs. Multiposting:

http://www.blakjak.demon.co.uk/mul_crss.htm

"John Smith" <3rtwemte001@sn eakemail.com> wrote in message
news:okc0d01pao vptdj843kc0v1ud n9682s9vr@4ax.c om...[color=blue]
> 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!
>
>
>[/color]

[John Smith]

Re: Searching TEXT column

Sorry :(

On Wed, 16 Jun 2004 08:47:43 -0400, "Bob Barrows [MVP]"
<reb01501@NOyah oo.SPAMcom> wrote:

: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?
:>
:>
:Please do not multipost John. This is definitely a database-related question
:so .asp.db was the perfect group in which to post it. Posting it here as
:well did not increase your chances of getting an answer (most of us
:subscribe to both groups). On the contrary, if somebody had taken his time
:to answer it here, only to find that it was already resolved in the other
:group, that person may have been annoyed enough to ignore any future posts
:from you, thereby decreasing your chances of getting help in the future.
:
:There are times when you will not be sure which group is most appropriate,
:and you will want to post a question to both groups. In that situation, you
:should use the cross-posting technique, rather than posting the same message
:multiple times. To crosspost, put a semicolon-delimited* list of the
:newsgroups to which you wish to post in the To: header of your post and post
:it once. It, and any replies to it, will appear in all the newsgroups in
:your list. So, if I reply in .asp.db, my reply will also appear here in
:.asp.general.
:
:* ... or whatever delimiter is recognized by your news client
:
:Bob Barrows