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:
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 ?