title: Find and replace LIKE sql data
body: <p>I'm tring to run a find and replace query on some sql data using Management Studio. I basically want to remove the word FREE from any content.</p>
  
  <p>I tried running this query;</p>
  
  <pre><code>UPDATE    Table_1
  SET              ContentDetails = REPLACE(ContentDetails, 'FREE', '')
  WHERE     (ContentDetails LIKE '%FREE%')
  </code></pre>
  
  <p>But I get an error saying that data type text is invalid for argument 1 of replace function.</p>