find and replace for text field in Sql7 table

[Joe]

I have a one table with a text data type. I need to scan this field and replace one char with another. I have tried to creat a cursor to go to the database but I can not declare a data type of text to use the select replace command. Is there any tool or sp out there that can do this.

Thanks.

[Jim W]

Ugh. I had to do something similar a few years ago.

Unless there is some software available to do this, I think your best option is to use READTEXT with a couple of WHILE statements.

------------
Joe at 9/27/00 2:57:11 PM

I have a one table with a text data type. I need to scan this field and replace one char with another. I have tried to creat a cursor to go to the database but I can not declare a data type of text to use the select replace command. Is there any tool or sp out there that can do this.

Thanks.