Replacing a character

Hi

I have a table with column type as ntext. I need to modify the column value. I wanted to replace a given character\string with another one in this column. Any assistance on this is highly appreciated.

Thanks!

Santhosh

Santhosh,

1) If the text in the column is not too long, you can cast ntext to nvarchar and use replace function.

2) check this link http://www.webpowersoftware.co.uk/FORUMS/ShowPost.aspx?PostID=336

rgds,

v r kumar

replacate Inserts only

Running Win 2k & SQL 2k
How do I create or modify an already created publication
to only replacate Inserts?
Larry,
assuming you are using transactional replication, usually the way to
accomplish this is to change the command called to NONE on the article
properties. However this will force reinitialization of existing
subscriptions. In order to avoid reinitialization, you could modify the
stored procedure called - comment out the code in the update and delete
stored procedures.
HTH,
Paul Ibison
|||So, if the publications have not been created, I can
create them and change the command called to NONE on the
article properties for the delete and update, and this
should work...RIGHT?
Thanks,
Larry...
|||Larry - that's right
Paul
|||thanks, you da man!!!