title: SQL Server query brings unmatched data with BETWEEN filter
body: <p>I'm querying on my products table for all products with code between a range of codes, and the result brings a row that should't be there.</p>
  
  <p>This is my SQL query:</p>
  
  <pre><code>select prdcod
  from products
  where prdcod between 'F-DH1' and 'F-FMS'
  order by prdcod
  </code></pre>
  
  <p>and the results of this query are:</p>
  
  <pre><code>F-DH1
  F-DH2
  F-DH3
  FET-RAZ       &lt;-- What is this value doing here!?
  F-FMC
  F-FML
  F-FMS
  </code></pre>
  
  <p>How can this odd value make it's way into the query results?</p>
  
  <p>PS: I get the same results if I use <code>&lt;=</code> and <code>&gt;=</code> instead of <code>between</code>.</p>