If you expect your text values to be compared as integers, you need to write something like<code> CAST( my_text_resembling_a_number AS INT ) </code>for each such value. The inequality operators (which set includes BETWEEN) will not do it for you.
If you expect your text values to be compared as integers, you need to write something like<code> CAST( my_text_resembling_a_number AS INT ) </code>for each such value. The inequality operators (which set includes BETWEEN) will not do it for you.