I cannot select rows from a table using the WHERE clause and cannot find my error. Perhaps others will see what I miss.
The table, Companies, has 1500+ rows. One column is defined as state CHAR(2), but the select statement seeking all rows where state = 'OR' for example returns nothing: sqlite> select * from Companies where state = 'OR'; sqlite> If I specify a single column in the above the same lack of returned rows is seen. A select * from Companies statement returns all rows with no error messages; so does a count statement: sqlite> select count(distinct state) from Companies; 5 Also, it does not matter which column I specify in the WHERE clause, no rows are returned. What simple, embarrassing error have I made in the syntax of the SELECT statement when I add the WHERE clause? Rich _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
