title: How to select where like multi line string in SQL text field?
body: <p>I'm using SQL Server and have a table with a text column spanning many lines, like this:</p>
  
  <pre><code>[textfield]
  blah blah
  blah
  
  yackety
  shmackety
  
  blah blah
  </code></pre>
  
  <p>I want to</p>
  
  <pre><code>select * 
  from table
  where [textfield] like '
  %
  yackety
  shmackety
  %
  '
  </code></pre>