On 14 September 2010 14:45, Rich Shepard wrote: > sqlite> select * from Companies where state = 'OR';
What do you get from: select distinct state from companies; Paul. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users