FREE - SQLtNoCase - convert TEXT columns to TEXT COLLATE NOCASE
SQLite handles text columns different, depending on how COLLATE is defined when the column is created. The default is COLLATE BINARY.
TEXT or TEXT COLLATE BINARY - columns will be treated case sensitive for ORDER BY and WHERE comparisons.
TEXT COLLATE NOCASE - columns will be handled case insensitive. 'smith' = 'Smith'
For the most part, TEXT COLLATE NOCASE will give the preferred results on short text columns such as [Name].
While SQL can be used to force case insensitive comparisons - converting a column to TEXT COLLATE NOCASE is a permanent solution.
Converting a column from TEXT, to TEXT COLLATE NOCASE, isn't easily done with SQL - that's where SQLtNoCase comes in.
http://www.sqlight.com/sqltnocase/ sd _ at _ sqlight _ dot _ com