Yes, that was the problem thanks. Even though sqlitebrowser declared them as empty with '' !
On 17 September 2012 15:50, Black, Michael (IS) <michael.bla...@ngc.com>wrote: > Or just fix the existing table: > > update members set year2007=NULL where year2007=''; > update members set year2008=NULL where year2008=''; > update members set year2009=NULL where year2009=''; > update members set year2010=NULL where year2010=''; > update members set year2011=NULL where year2011=''; > update members set year2012=NULL where year2012=''; > > Then the counts should be what you want. > > I'll note that Oracle doesn't count ''. whereas sqlite3 does. Does the > SQL standard say anything about what a "NULL" value is? And who's correct > here if there is a standard? > > > > Michael D. Black > Senior Scientist > Advanced Analytics Directorate > Advanced GEOINT Solutions Operating Unit > Northrop Grumman Information Systems > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users