title: Use REPLACE on column data type TEXT SQL Server
body: <p>I try use this code to resolve acute accent on column type text:</p>
  
  <pre class="lang-sql prettyprint-override"><code>UPDATE [AcuerdateWEB].[dbo].[Actividad]
  SET Descripcion = REPLACE(CAST(Descripcion AS nvarchar(max)), 'ó', '&amp;oacute')
  WHERE Descripcion like '%&amp;oacute%'
  </code></pre>
  
  <p>The problem is that the column's datatype is <code>text</code> and can not be replaced; but when I use the code above appears that the query was successfully and show the total of rows affected</p>