title: Using 'NONE' literal string in SQL where criteria seems to be getting confused with NULL data
body: <p>%It appears as though SQL is confusing 'NONE' with null in my environment but also recognizing 'NONE' somehow... </p>
  
  <p>I have googled and searched StackOverflow. I see that NONE is a reserved word but I wouldnt expect that to matter as a string in quotes. Search terms included 'Reserved word in SQL where criteria' and ' 'NONE' in SQL where criteria' and nothing I found really helped.</p>
  
  <p>All of the following commands are being ran directly through SQL server 2008 R2 SQL Server Management Studio. Query C does not give me the output I expect</p>
  
  <pre><code>Query A
  SELECT COUNT (*)
  from tbl 
  WHERE id LIKE 'ABCV%' 
  --20118 records
  
  Query B
  SELEC tbl
  WHERE id LIKE 'ABC%' and fielda = 'NONE'
  --10 records
  
  Query C
  SELECT COUNT (*)
  from tbl
  WHERE id LIKE 'ABC%' and fielda != 'NONE'
  --15695 records (Why?? - I expect 20118 - 10 = 20108 records)
  
  
  
  Extra - but possibly useful information
  
  
  
  Query D
  SELECT count(*)
  from tbl 
  WHERE id LIKE ABC%' and fielda is null
  --4410 records
  
  Query E
  SELECT tbl
  WHERE id LIKE 'ABC%' and fielda is not null
  --15708
  </code></pre>
  
  <p>I appreciate any assistance or light anyone may be able to shed. Thank you!</p>