title: SQL LOWER (or UPPER) vs Like
body: <p>I have a table that isn't going to get very big and contains the name of a <em>client account</em> and a <em>user's alias</em>. I'm importing this information from production in order to run a few reports.</p>
  
  <p>To help out with management of the table contents, I'm adding a simple AddUser stored procedure where first I want to check if the <em>client account/alias</em> combo already exists in the table. </p>
  
  <p>Since I want this check to be case insensitive, I considered using <code>LOWER</code> or <code>like</code> when comparing the values.</p>
  
  <p>Probably in this scenario, I wouldn't see a big difference either way with regard to performance, but it made me wonder if there is a best practice when doing this sort of thing.</p>
  
  <p>many thanks!</p>