I can't use "int" because of the length of the numbers. If I cast the query as "long", can you guarantee that all query ranges will run without errors? My Query will be; SELECT * FROM my_table WHERE 4011110000001 BETWEEN CAST(col_a AS LONG) AND CAST(col_b AS LONG)