• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 337
  • Last Modified:

Replace on an NTEXT field in Sql 2000

Hi Folks,

I have ntext fields containing XML which are all longer than 4000 characters in a sql 2000 DB

I need to do the following replace on them:

update MyTable
Set SourceQuery = Replace(Replace(cast(SourceQuery as nvarchar(4000)), '<SCR>', '<PX>0</PX><SCR>'), '</Order>', ',PX</Order>')
Where SourceType = 'X334'

Without reinventing the wheel, how can I get this done ?

thanks

0
plq
Asked:
plq
1 Solution
 
plqAuthor Commented:
@anee... how does that help ? I don't know how to turn that into a solution that does the replace ??
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now