title: SQL Server like statement behavior for %%
body: <p>In terms of performance, how does the <code>like</code> operator behaves when applied to strings with multiple % placeholders?</p>
  
  <p>for example:</p>
  
  <pre><code>select A from table_A where A like 'A%' 
  </code></pre>
  
  <p>takes the same time to select than</p>
  
  <pre><code>select A from table_A where A like 'A%%' 
  </code></pre>
  
  <p>???</p>