title: SQL Server case insensitive queries
body: <p>I want to ignore case when comparing string in my queries using SQL Server. So far I am able to do it using something like this:</p>
  
  <pre><code>SELECT *
  FROM Venue
  WHERE
     Name COLLATE Latin1_general_CI_AI Like '%cafe%' COLLATE Latin1_general_CI_AI
  </code></pre>
  
  <p>Is there a way to set a global directive so that it would effect every query?
  Something like this:</p>
  
  <pre><code>SET COLLATE Latin1_general_CI_AI;
  SELECT *
      FROM Venue
      WHERE
         Name Like '%this%';
  SELECT *
      FROM Venue
      WHERE
         Name Like '%that%';
  ...
  </code></pre>
  
  <p>Thank you!</p>