title: ZLS vs 1 char space
body: <p>Something that has totally shocked me, and made me feel like an absolute fool.</p>
  
  <pre><code>select count(*) as [row count], myField as FieldValue, len(myField) as ValueLength
  from myTable
  where myField=N''
  group by myField,len(myField)
  </code></pre>
  
  <p>Returns a record with a healthy Count, and  [ValueLength] of 0.</p>
  
  <p>Now if I change the WHERE clause to : <code>where myField=N' '</code>
  (i.e. change from a ZLS to a {space})</p>
  
  <p>The query now returns exactly the same result ?</p>
  
  <p>How can this be?
  Surely SQL Server knows the difference between a ZSL and a space ?
  May it's me that does not understand !?</p>
  
  <p>Please can someone enlighten me as to what's going on under the hood here ?</p>
  
  <p>Many Thanks</p>