On Tue, Sep 14, 2010 at 06:52:02AM -0700, Rich Shepard scratched on the wall: > On Tue, 14 Sep 2010, Paul Corke wrote: > > > What do you get from: > > > > select distinct state from companies; > > Paul, > > 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'". -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
