title: SQL: LIKE query on column with chr(10) or chr(13)
body: <p>I am doing a </p>
  
  <pre><code>select field1 
  from tablename 
  where field1 like '%xyz zrt bla bla trew%'
  </code></pre>
  
  <p><code>field1</code> is a clob column and between the <code>'xyz zrt bla bla trew'</code> there might be new line characters like chr(10) or chr(13). So it might be  <code>'xyz\r\n\rzrt bla bla\n\n trew'</code> etc</p>
  
  <p>These are being converted to one (or more spaces). So any spaces between words can be true spaces or one or more of those new line characters.</p>
  
  <p>How do I take this into account in my <code>LIKE</code>?</p>
  
  <p>I am using Oracle but if possible I would like to use something that works for SQL Server, etc.</p>