On Sun, Dec 06, 2009 at 07:54:45PM -0500, Walter Dnes scratched on the wall:
> The last few rows of the query output are... > > 2009| 9| 21 > 2009| 9| 22 > 2009| 9| 23 > 2009| 9| 24 > 2009| 9| 25 > 2009| 9| 26 > 2009| 9| 27 > 2009| 9| 28 > 2009| 9| 29 > 2009| 9| 30 > > So I *KNOW* that there are rows with local_year = 2009. But... No, there are rows with a TEXT value of ' 2009'. Note the space. Your other columns have leading whitespace as well. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
