On 8 Jul 2012, at 7:15am, Corey Nelson <corey.nel...@gmail.com> wrote:
> sqlite> SELECT * FROM GBP_CHF_BID WHERE price LIKE "12.%"; If price is a numeric field, then instead of the above, use > SELECT * FROM GBP_CHF_BID WHERE price >= 12 AND price < 13; Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
