Thread: MS SQL Server General Questions/How to use REPLACE() within NTEXT columns in SQL Server

    
09 November 2011

21:04:12
sergey


Posts: 0

How to use REPLACE() within NTEXT columns in SQL Server

 



begin transaction rr1



update [mojoJIH].[dbo].[mp_HtmlContent] SET [Body] = cast(replace(cast([Body] as nvarchar(max)),'/mojoJIH/Data/','/Data/') as ntext)


select [Body] from [mojoJIH].[dbo].[mp_HtmlContent]


rollback transaction rr1