PL/SQL compare more values using between
<p>I have a problem with my query. I need to compare more than 50 values if it is between 2 columns. For example, I have two varchar columns:</p>

<pre><code>col1   col2
-----------
1000   1999
2000   2999
3000   3999
</code></pre>

<p>and I have values <code>1001, 2001, 3001, 4001</code>.
And I need table with input data and column with <code>Y</code> or <code>N</code> if value is between col1 and col2:</p>

<pre><code>input  Y/N
-------------
1001   Y
2001   Y
3001   Y
4001   N
</code></pre>

<p>I tryed to use IN() but it is not possible use for between.
Can you give me an answer.
Thx</p>