SQLite Forum

Inconsistency in BETWEEN Query
Login
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)