Aargh! Should have paid attention to that Collation-Thing right away. And try it for myself.
@Rob Willett: try "select Id,Calculation,Peak,Red,Amber,Green from RAG where text = ? COLLATE NOCASE" sqlite should then choose Rag_Idx1 without being forced to. In general, Collations should be defined on the Table definition. Create Indexes with specific Collations only when absolutely necessary. hth Gerd
