I'm attempting to use the following query to update the substring %/themes/old/%
with '%/themes/new/%'
update bodyTextTable
set bodyText = replace (bodyText, '%/themes/old/%', '%/themes/new%')
But I am returned the following error -
Msg 8116, Level 16, State 1, Line 15
Argument data type ntext is invalid for argument 1 of replace function.
So to get round the ntext issue, I have used executed the following...
update bodyTextTable
set bodyText = replace (bodyText, '%/themes/old/%', '%/themes/new%')
But the expected changes are not reflected in the table.