I've searched archives and found some good stuff.
However when I run on my table (field in ntext)
I seem to randomly(?) chop my text field .
Any pointers
Many thanks in advance
TabbyTab
However when I run on my table (field in ntext)
Code:
update <tablename>
set <field> = replace(cast(field as nvarchar),char(13)+char(10),'xyz')
I seem to randomly(?) chop my text field .
Any pointers
Many thanks in advance
TabbyTab