On Sun, Dec 06, 2009 at 08:15:46PM -0600, Jay A. Kreibich wrote > 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.
sqlite> select local_year, local_day, local_month from dly.dly04 where ((national_identifier = '615HMAK') and (local_year = ' 2009') and (local_month = ' 9') and (local_day = ' 30')); ...gives the result... 2009| 30| 9 So you're right. One correction to my previous post; I imported as comma-delimited, i.e CSV. I still don't understand why 2009, *WITHOUT QUOTES* would be forced to text, i.e. ' 2009', when imported into a field that is declared as integer in the create statement. -- Walter Dnes <waltd...@waltdnes.org> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users