J Trahair <j.trahair@...> writes: [...]
> SELECT * FROM Customers WHERE CustomerCode = 'tra001' > that is, with tra001 in > lower case, SQLite *does not find the record*. [...] use LIKE (http://www.sqlite.org/lang_expr.html#like) SELECT * FROM Customers WHERE CustomerCode LIKE 'tra001' Oliver _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
