title: Comparing values with VARCHAR2 in oracle sql developer
body: <p>I am trying a very simple query which returns the results which are less than some particular value.  I am using the below query</p>
  
  <pre><code>SELECT
      *
  FROM
      ok_dc.gms3_vc_mme_vin_si_detail
  WHERE
      vc_vin_locale = 'en_EU'
      AND vc_vin_document_id = 'SI120804'
      AND vc_vin_vis_start_range &lt;= '670702';
  </code></pre>
  
  <p>However, as shown below the data returned is not accurate. The data type of VC_VIN_VIS_START_RANGE is VARCHAR2.  I read Oracle documentation, it was said that automatic conversion will be made while doing comparisons. </p>
  
  <p>I need help with understanding what is wrong with the query or other possible solutions for handling this case.  </p>
  
  <p>Appreciate any help!</p>
  
  <p><a href="https://i.stack.imgur.com/1Rwah.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1Rwah.png" alt="enter image description here"></a></p>