title: How can I use REPLACE with LIKE statement SQL
body: <p>This is what I'm trying:</p>
  
  <pre><code>SELECT *
  
  FROM TABLE
  
  WHERE '0.21' LIKE '%' + REPLACE(COLUMN_NAME,'%','[%]') + '%' 
  </code></pre>
  
  <p>What I want is to select a record with the value <code>'21%'</code> and not <code>'0%'</code>. </p>
  
  <p>But all I can get is `'21%' AND '0%'’ or none of both. </p>