title: Merge two SQL queries - unable to use WHERE clause with between option in postgres
body: <p>I have these two SQL queries:</p>
  
  <pre><code>select * 
  from table1 
  where table1.item_no::character varying between '2000' and '3000' 
    and batch_id = 'new'
  </code></pre>
  
  <p>and</p>
  
  <pre><code>select * 
  from table1 
  where table1.item_no::int between '2000' and '3000' 
    and batch_id = 'new'
  </code></pre>
  
  <p><code>item_no</code> datatype is character varying.</p>
  
  <p>How to merge the above two SQL queries in postgres?</p>