To add on...it does NOT work under 3.7.3...so perhaps that's what you're using? I agree this doesn't seem intuitive at all... 4|87|3|4|B 11|76|8|11|A sqlite> select count(*) from test; 1 Michael D. Black Senior Scientist Advanced Analytics Directorate Northrop Grumman Information Systems
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users