Quoth Corey Nelson <corey.nel...@gmail.com>, on 2012-07-08 00:15:36 -0600: > sqlite> SELECT * FROM GBP_CHF_BID WHERE price LIKE "12.%";
Aside from the more immediately relevant aspects the other posters already mentioned, remember that double quotation marks in SQL are normally used for _identifiers_. For string literals, use single quotation marks. SQLite will sort of autocorrect the former into the latter sometimes, but it is not good practice to rely on this. ---> Drake Wilson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users