For SQLite the integer can be up to 8 bytes and will casting as "INTEGER" solve the problem without overflow? My Query will be; SELECT * FROM my_table WHERE 4011110000001 BETWEEN CAST(col_a AS INTEGER) AND CAST(col_b AS INTEGER)
For SQLite the integer can be up to 8 bytes and will casting as "INTEGER" solve the problem without overflow? My Query will be; SELECT * FROM my_table WHERE 4011110000001 BETWEEN CAST(col_a AS INTEGER) AND CAST(col_b AS INTEGER)