I need to write update statement to update column data (this column is of data type text)
So i am using the following statement
UPDATE tableName set clnName = str_replace(convert(varchar(16384),clnName), 'ABC', 'XYZ') WHERE ClnId = 1

Since data type text can hold larger size than varchar , the data is getting truncated when i use the convert function, any idea on how to get this working?