title: The data types varchar and varchar are incompatible in the modulo operator SQL Server
body: <p>I get this error:</p>
  
  <blockquote>
    <p>The data types varchar and varchar are incompatible in the modulo operator.</p>
  </blockquote>
  
  <p>when running this code</p>
  
  <pre><code>' Number LIKE '%' + @search + '%' ';
  </code></pre>
  
  <p>The number is an integer and this code snippet appears enclosed in ''; due to a dynamic pivot statement. Any ideas how  i can run this? thanks</p>