title: Queries using LIKE wildcards in sql server
body: <p>I want to perform a small SQL server search in my ASP.NET web project. My database is not big so I think it's better not to use full-text-search.</p>
  <p>I want to perform a simple search like this:</p>
  <pre><code>select * from mytable where columnA LIKE '%something%'
  </code></pre>
  <p>I can use <code>=</code> in the following way:</p>
  <pre><code>select * from mytable where columnA='&quot;+myVariable+&quot;'
  </code></pre>
  <p>but how can I use a variable instead of <code>%something%</code> in the LIKE phrase?
  Is this correct:</p>
  <p><code>LIKE '&quot;+%myVariable%+&quot;'</code>?</p>