Hello, I need help with the following question:
Is there a way to make SQLite queries case-insensitive? For example my query is: SELECT * from Customers WHERE LastName = 'Shaw' AND FirstName = 'Gioia' and I want to be able to get same results no matter if the case is good in the DB or not or in the query. Currently, I am using LIKE as the following: SELECT * from Customers WHERE LastName like 'Shaw' AND FirstName like 'Gioia' to take care of case-sensitivity, but I believe there is a performance penalty associated with using LIKE in SQLite. Is this true? Cheers! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
