title: Main reason of using "^"
body: <p>I don't understand what  what the purpose of using "^" in the second code?<br>
  Another problem is that I don't retrieve right information in second code compare to the first code. Why? </p>
  
  <pre><code>-- First code, use adventurework DW 2008
  select FirstName, LastName from DimCustomer
  where LastName like '[j-N]%'
  order by LastName
  
  -- Second code, use adventurework DW 2008
  select FirstName, LastName from DimCustomer
  where LastName like '[^L-N]%'
  order by LastName
  </code></pre>