UPDATE error: “Argument data type text is invalid for argument 1 of REPLACE” August 31, 2023 by Tarik Try this: UPDATE tableName SET fieldName = REPLACE (CONVERT(VARCHAR(MAX), fieldName), '<', '<') WHERE id = 100