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