title: Specified "COLLATE Latin1_General_CS_AS", query result still "case insensitive"
body: <p>I want to only selects rows from a table where the last name of the employees stands with a lowercase letter. However, when I run the query below</p>
  
  <pre><code>SELECT empid, lastname
   FROM HR.Employees
   WHERE lastname COLLATE Latin1_General_CS_AS LIKE '[a-z]%';
  </code></pre>
  
  <p>it returned all rows where the employees' last name starts with either lowercase letter or uppercase letter.</p>
  
  <p>I have already specified that the query should be case sensitive with <code>COLLATE Latin1_General_CS_AS</code>, how come it is not filtering out last name that starts with capital letter? </p>