On 14 September 2010 14:52, Rich Shepard wrote:
> sqlite> select distinct state from Companies;
> 'ID'
> 'NV'
> 'OR'
> 'UT'
> 'WA'
It looks like the values in your db have quotes in them.
sqlite> create table companies(state char(2), name char(10));
sqlite> insert into companies values('OR','one');
sqlite> insert into companies values('OR','two');
sqlite> insert into companies values('ID','three');
sqlite> select * from companies where state='OR';
OR|one
OR|two
sqlite> select distinct state from companies;
ID
OR
Note the difference between OR and 'OR' in the two responses.
Paul.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
