title: Search within all text in varchar(max) column
body: <p>As a result of Googling, it turns out that both <code>LIKE</code> operator and <code>CHARINDEX()</code> function search only first 8K of varchar(max) column.</p>
  
  <ol>
  <li>Is this a correct statement?</li>
  <li>If so, how to search for a substring in full text of varchar(max) column without enabling full text search feature (if this even makes sense)?</li>
  </ol>
  
  <p><strong>UPDATE</strong>: Search beyond 8K doesn't work for me on <strong>SQL Server 2008 (10.0.5538.0).</strong></p>