On 11 Mar 2010, at 4:13pm, Skand wrote: > sqlite> select count(*) from ip_domain_table where ttl < 9999999999 ; > > 258 > > sqlite> select * from ip_domain_table where ttl < 9999999999 limit 1; > 107.35.138.41|127.2.0.2|1266895619
Although you have defined your column type as INTEGER, it's possible that you have some values in that column which are of other types. Even the record you show may have been put into the file with '1266895619' representing a TEXT value. I believe that a text value would not satisfy your WHERE clause in a consistent manner. Can you try something like SELECT ttl,typeof(ttl) FROM ip_domain_table WHERE ttl < 9999999999 LIMIT 10 Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users