[EMAIL PROTECTED] wrote: > > What's driving me mad is that when I do a select from the command line > like so: > > sqlite3 test.db `select name from PerfTest1 where name = "key5000"' > > 0 rows are returned. However if I do a simple: > > sqlite3 test.db 'select name from PerfTest1' > > and just let it go it prints all 10000 rows!!
Could it be that the data in the name column have a blank before or after the "key5000"? SQLite does not automatically trim its data. HTH, Gerry _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
