On 14 Sep 2010, at 2:57pm, Jay A. Kreibich wrote: > On Tue, Sep 14, 2010 at 06:52:02AM -0700, Rich Shepard scratched on the wall: >> sqlite> select distinct state from Companies; >> 'ID' >> 'NV' >> 'OR' >> 'UT' >> 'WA' > > If that's a copy-paste from a default sqlite3 session, the single > quotes are part of the value. i.e. you have four-character values, > such as "'ID'".
In the year 2060, when computers are unbelievably clever and we're all programming by mental control, we will still have the problem of identifying which meta-level quote marks are in. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
