[sqlite] Re: ORDER BY clause with column values not case-sensitive

[Igor Tandetnik]

Dennis Cote <[EMAIL PROTECTED]> wrote:
Srikanth wrote:
Is there a way to order the results of a select statement using the
values of a column name, with the values in that column insensitive?

Add COLLATE NOCASE to the column definition of the country column in
your table.

... or directly in the ORDER BY clause, without modifying the table 
schema:

select * from tableName
order by fieldName collate NOCASE;

Igor Tandetnik