title: What is difference between below two Conditions?? 1. where ABC>='00' and ABC<='ZZ' 2.where ABC>='0' and ABC<='Z'
body: <p>Many of report and Developers team must be using the condition </p>
  
  <pre><code>where ABC&gt;='00' and ABC&lt;='ZZ' 
  </code></pre>
  
  <p>i.e to select/refer all data from that column. My question is what is difference between below two conditions??</p>
  
  <p>1.</p>
  
  <pre><code>where ABC&gt;='00' and ABC&lt;='ZZ'
  </code></pre>
  
  <p>2.</p>
  
  <pre><code>where ABC&gt;='0' and ABC&lt;='Z'
  </code></pre>
  
  <p>as I have got different results with these two condition </p>