Replace part of a field with update and replace in SQL

Replace part of a field with update and replace in Sqlsever

Update users_settings set Replace field = replace (replace field, ' original content ' ' new content ') where ' configname ' = ' accesslist '

SQL Error "parameter data type text is not valid for parameter 1 of the Replace function"

Data for text or ntext types cannot be string-manipulated in queries. The most used is to use text as a varchar (actual content length less than 8000 bytes) or ntext as nvarchar (actual content length less than 4000 bytes) to handle

Update Table Set Column=replace (Cast (Column as varchar (8000)), ' Oldkeyword ', ' Newkeyword ')

Update Table Set Column=replace (Cast (Column as nvarchar (4000)), Oldkeyword ', ' Newkeyword ')

Replace part of a field with update and replace in SQL