How do I replace strings in Text datatype without truncating to 8000 chars
Posted on 2011-09-12
I have a Text Datatype column and I need to replace some of the strings within them. I did try to use the REPLACE function like so:
UPDATE <Table> set textcolumn=
However I have now discovered that the SUBSTRING truncates to 8000 chars.
I am using SQL Server 2005.
How can I do a replace in this Text column without truncation.