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.