What is the best/most efficient way to perform comparisons or joins on data where case sensivitiy is not important?
e.g join two tables where the primary and foreign key values have different case? Best to use Like or upper() or Lower() or some other way of ignoring case? Thanks, Mike -- View this message in context: http://www.nabble.com/case-insensitive-joins-and-comparisons-t1736367.html#a4718438 Sent from the SQLite forum at Nabble.com.
