UPDATE error: "Argument data type text is invalid for argument 1 of REPLACE"

Question

Why do I get this error from my query?

Msg 8116, Level 16, State 1, Line 3
Argument data type text is invalid for argument 1 of replace function.

Query:

UPDATE 
    tableName
SET
    fieldName = REPLACE (fieldName, '&lt;', '<')
WHERE
    id = 100

Answer 1

Try this:

UPDATE tableName
SET fieldName = REPLACE (CONVERT(VARCHAR(MAX), fieldName), '&lt;', '<')
WHERE id = 100

Answer 2

this will work for you

UPDATE yourTableName
SET 
fieldName = REPLACE (CONVERT(VARCHAR(MAX), fieldName), '&lt;', '<')
WHERE id = 100